Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load field
From file.xls (...)
Where len(field);
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
Thanks for your help !
It works now and thanks very much!!