Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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