Handle Null values while data loading

[Anonymous]

Hi

I want to know how to pass some value like 0 or NA to the fields while loading the data in QlikView or QS (in script), I don't want to avoid those records, I need them. @HIC

@Henric Cronstrom , Could you please reply.

[karthikoffi27se]

Hi Ankita,

You need to set a valyue for null

NULLASVALUE *;

SET Nullvalue = '<Null>';

Many Thanks

Karthik

[tresesco]

HIC has already explained it here : NULL handling in QlikView very nicely.