Null value in inline

[harveenkaur]

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.

[tresesco]

Add the below line before your load statement.

SET NullInterpret='';