Empty Strings to Nulls

m_perreault — Fri, 08 Jun 2018 14:21:06 GMT

Hi All,

I am loading in a file to Qlik Sense that contains many empty strings as shown below.

I know in the script I can do

If(Len(Trim(Id)) <1, Null(),Id) as Id

But this table has 80+ fields and I believe this will be the case for other tables I am bringing in.

Is there a way for me to tell Qlik to universally treat strings with Len(Trim(Field)) = 0 as nulls?

Thanks,
Mark

Re: Empty Strings to Nulls

m_perreault — Fri, 08 Jun 2018 14:30:26 GMT

Found the answer reading here.

Set NullInterpret = '';