Skip to Content
0
Former Member
Mar 12, 2013 at 10:44 AM

Warning: Cannot convert data <\N> into type <INTEGER>

49 Views

Hi experts,

I am trying to load MYSQL dump file into HANA table. Within the file, there are fields that null is allowed for and they have "/N" value.

For that transformation, I am using a script like:

ifthenelse(VariationDump.CLASS_ATTRIB_ID <> '\N',VariationDump.CLASS_ATTRIB_ID,null)

the problem arise when the field is integer or double - than I get the warning.

could you please advise?

Thanks,

Amir