I have to create a data load mapping and I have a issue with a field that is NULL (No spaces).
My file has tab separator and second column could be empty. I add an image to better understanding.
In this snapshot there isn't any space. So in second line of data is NULL value (no space).
If I add this mapping not work:
Also I try to apply a #SQL using Like expression, but neither works...
Is possible to fix this issue?
I'm using PBCS, so I can read that No Jython or Groovy scripting available in Cloud DataManagement.
I'm using SQL Script and it works if I type this code:
CASE WHEN UD2 is NULL THEN 'None' END