Upload "blanks" with default value

[#1]

Hi everyone,

In one column of my Excel raw data file there are some "blanks", where no value is assigned to the row (yet).

Is there any way to assign a default value to these blank fields?

Thanks in advance,

Lina

[er_mohit · Accepted solution]

Hi in qlikview write condition for that particular field

like

If(len(Field)=0,'Default',Field) as NewField

[PrashantSangle]

Hi,

If you want to write in script

Then

try like

IF(ISNull(FieldNAme) or len(trim(FieldName))=0,'No Data') as NewFieldName.

or

If you want to write in chart

then go to Presentation->Null Symbol->write Value

Regards

[ariel_klien]

Hi,

you can do in the script...

load if(isnull(Column),defalt_value,Column) as Column

from xlsx

BR

Ariel

[#5]

Thanks! Works perfectly!