how to filter blank cell from the excel files

[#1]

Dear all,

I met a problem when uploaded data from excel files.

One of the fields has blank cells that contain nothing, and it should be filtered. But I've tried to use null or ' ' that none of them can succeed.

Could you please help me on this issue?

Many thanks and thanks in advance!!

Br,

Lisen

[MarcoWedel · Accepted solution]

Load field

From file.xls (...)

Where len(field);

[its_anandrjs]

Hi,

There are many ways to do this or you can try

Load * from Source

Where Len(Field) > 0;

Or

You can create the Null flag and in front end use with expression to filter nulls

Ex:-

LOAD If(Len(ColB) = 0,1,0) as Flag,*;

LOAD * Inline [

ColA,ColB

a,34

b,3

c,

d,

e,34

];

sum({<Flag -= {1}>}ColB)

Regards

Anand

[#4]

Thanks for your help !

[#5]

It works now and thanks very much!!