How to select null values?

[#1]

I need to make selection of null values and check the data variation. So how should i do it in the script for the particular field?

[vijay_iitkgp]

Hi Priyanka,

You can use

If(IsNull(Field),'Null Value',Field) AS Field

[nstefaniuk]

Or

NullAsValue Field;
Set NullValue = 'Null Value';
// Make your final load here
Load
...
;
NullAsNull Field;

More performant than the If