topic Re: Replace all empty strings with some value in entire script. in QlikView

Replace all empty strings with some value in entire script.

retko1985 — Fri, 06 Apr 2018 12:24:51 GMT

Can I somehow do it easily for each field?

Thanks

Re: Replace all empty strings with some value in entire script.

sunny_talwar — Fri, 06 Apr 2018 12:27:34 GMT

May be something like this

NullAsValue

Re: Replace all empty strings with some value in entire script.

olivierrobin — Fri, 06 Apr 2018 12:27:36 GMT

hello

maybe you can use

nullasvalue

NullAsValue *fieldlist

of the NullAsValue statement.

The NullAsValue statement operates as a switch and will operate on subsequent loading statements. It can

be switched off again by means of the NullAsNull statement

Re: Replace all empty strings with some value in entire script.

sunny_talwar — Fri, 06 Apr 2018 12:28:34 GMT

A youtube video on the topic

Convert Null values using NullAsValue statement in QlikView - YouTube

I have not seen it, but I think it should help

Re: Replace all empty strings with some value in entire script.

retko1985 — Fri, 06 Apr 2018 12:32:40 GMT

Hi,

I don't have null values but empty strings from excel. Is here a similar way for this?

Thank you.

Re: Replace all empty strings with some value in entire script.

sunny_talwar — Fri, 06 Apr 2018 12:36:14 GMT

Well that would be somewhat more challenging...may be loop through each field and use ApplyMap to change blanks to something else

Re: Replace all empty strings with some value in entire script.

marcus_sommer — Fri, 06 Apr 2018 13:57:33 GMT

I think you could adapt these approach: Filling Default Values Using Mapping | Qlikview Cookbook.

- Marcus

Re: Replace all empty strings with some value in entire script.

Ken_T — Thu, 18 Nov 2021 21:59:30 GMT

@retko1985 did you ever find a way to do this? Did anyone else?
I have not found a good clean way to do this in load script.
for a column which has many values that are an empty string. NOT NULL, and zero length.