Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

adlisval
New Contributor III

Handle NULL when LOAD multiple CSV

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);

QS_Null.png

Tags (2)
1 Reply
yvonne_klich
New Contributor

Re: Handle NULL when LOAD multiple CSV

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

Community Browser