Handle NULL when LOAD multiple CSV

adlisval — Wed, 28 Mar 2018 12:43:31 GMT

I load 2 CSV files and I get many values of "-" (see image), which I guess means NULL (and that's fine). The reason, I guess, is because of missing values, which is also fine, because I want to see those missing values.

THE PROBLEM is that I cannot filter only on those missing values, so I want to replace the missing values with a string like i.e. 'NULL'

How can I do that? Here's what I tried (Qlik Sense version 3.2):

NullAsValue *;

Set NullValue = 'NULL';

// set NullInterpret='';

// SET NULLDISPLAY='NULL';

LOAD

"s-p-n",

title as m_title

FROM [lib://Other/mss-m.csv]

(txt, utf8, embedded labels, delimiter is ',', msq);

LOAD

"s-p-n",

"p-p-nr" as [s_p-p-n],

e as s_e,

title as s_title

FROM [lib://Other/mss-q.csv]

(txt, utf8, embedded labels, delimiter is ',', msq);

Re: Handle NULL when LOAD multiple CSV

Anonymous — Mon, 16 Apr 2018 09:27:15 GMT

Hi Adli,

I´m no expert, but one more guess would be to load the field like:

if ( isNull(<field>),'empty', <field>) as field.

Just a wild guess though, good luck ^^

Cheers,

Yve

topic Re: Handle NULL when LOAD multiple CSV in App Development

Handle NULL when LOAD multiple CSV

Re: Handle NULL when LOAD multiple CSV