topic Fill in empty fields by loading a table in QlikView

Fill in empty fields by loading a table

Wed, 21 Jan 2015 13:08:34 GMT

Hello,

Loading the table, the empty fields has to get a default text like "Not_Filled_in".

The fields that are not empty has to be load of course.

I forgot the script text.

Can you help me with this easy question.

Thanks,

Ralph

Wed, 21 Jan 2015 13:10:53 GMT

Hi Ralph,

something like

If(Len([Field])>0,[Field],'Not_Filled_in') AS [Field]

in your load script should do the trick for you, will catch zero length and null values.

Alternately have a look at the 'map using' function if this to be a wider requirement across a large number of fields

hope that helps

Joe

sunny_talwar — Wed, 21 Jan 2015 13:17:19 GMT

Are you looking to do something like this?

Table:

Load If(IsNull(FieldName), 'Not_Filled_in', FieldName) as FieldName

Resident SourceFile;

Best,

Wed, 21 Jan 2015 13:32:46 GMT

Thanks,

It works.

Wed, 21 Jan 2015 14:06:00 GMT

no problem, glad to help