Fill in empty fields by loading a table

[#1]

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

[#2 · Accepted solution]

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]

Are you looking to do something like this?

Table:

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

Resident SourceFile;

Best,

S

[#4]

Thanks,

It works.

[#5]

no problem, glad to help