Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to figure out how to replace the '-' that comes for empty null values after joins. After joining two tables, my data looks like this:
ID Object_1 Object_2
1 - Apple
2 Orange Banana
3 Grapes -
I would like to replace all the '-' with 'Null' so that they can be searched using a filter pane.
Did you try the following script to replace '' with NULL ?
test:
load ID,If(len(trim(Object_1))=0,'NULL',Object_1) as Object_1
,If(len(trim(Object_2))=0,'NULL',Object_2) as Object_2;
load * Inline [
ID, Object_1, Object_2
1,,Apple
2,Orange,Banana
3,Grape,
];