Removing Null Value in the Script

[samuel_brierley]

Hi im pulling data from an excel spreadsheet. the columns have a =if(cell="","",cell) which when loaded into qlikview produces null values. is there a way to remove these in the script?

[hic · Accepted solution]

You can add a where clause to the load statement:

Load ... From File.xls (biff, ...) Where Len(Trim(Field)) > 0 ;

HIC

[vipin_mishra479]

Hi,

use

where

len(field)>0

[#4]

if(Len(Trim(Field)) > 0,cell,' ')

[er_mohit]

in if condition write this way

if(Len(Trim(cell)) > 0,cell) as CellField

[samuel_brierley]

Thanks Guys youve all been a massive help

[#7]

Use this

len(field)>0

[kiranmanoharrode]

Dear Samuel,

Use following Where condition it works.

From................................

Where IsNull(Field)=0;

Regards,

Kiran Rode    

+91 897 6977897