Null value in inline

harveenkaur — Sat, 16 Nov 2024 04:08:42 GMT

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.

Re: Null value in inline

tresB — Tue, 12 Nov 2019 06:22:47 GMT

Add the below line before your load statement.

SET NullInterpret='';