Replace all empty strings with some value in entire script.

[retko1985]

Can I somehow do it easily for each field?

Thanks

[sunny_talwar]

May be something like this

NullAsValue

[olivierrobin]

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

[sunny_talwar]

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

[retko1985]

Hi,

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

Thank you.

[sunny_talwar]

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

[marcus_sommer]

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

- Marcus

[Ken_T]

@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.