topic Re: Inline load & null values in QlikView

Inline load & null values

whiteline — Sat, 01 Sep 2012 17:52:03 GMT

Hi.

Does anyone know another way of loading null() values with inline load ?

LOAD

if(NullField='NULL', null(), NullField) as NullField;

LOAD * INLINE [

NullField

NULL,

];

Anonymous — Sun, 02 Sep 2012 01:15:37 GMT

I think this is the only way in case of inline load. Leaving it blank returns blank that is not the same as null.

Regards,

Michael

hic — Sun, 02 Sep 2012 11:41:39 GMT

Michael is right. The inline Load is like a text file that cannot contain NULL values. See more on http://community.qlik.com/docs/DOC-3155.

HIC

marcelo_7 — Tue, 13 Nov 2012 15:51:15 GMT

Set NullInterpret = '';

LOAD * INLINE [

NullField,

];

DylanUK — Mon, 10 Feb 2020 12:23:02 GMT

(I realise this is an old post - but I found a solution others may find useful)

You can add null values using concatenate inline loads, but a field must be specified in each load. So a solution is:

LOAD * INLINE [
NullField, OtherField
1,
2,
3,
];
CONCATENATE LOAD * INLINE [
OtherField
1
];
DROP Fields OtherField;

I suspect for most cases other fields would exist - you would necessarily need to create (and drop) an 'OtherField'.