Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to assign NULL value (NOT Blank) in inline load to some value in row.Example:-
Load * inline [
Product,Product_Group, Sales
A,,1000
B,b,2000
]
;
In the above case for A product, product group is blank but I want it to be null.
Add the below line before your load statement.
SET NullInterpret='';