topic Garbage after statement in QlikView

Garbage after statement

Anonymous — Wed, 19 May 2010 03:47:01 GMT

It shows "Garbage after statement" when I run:

LOAD @7 as A,
@8 as B
FROM
[E&D final data_JL.xls]
(biff, no labels, table is [Q1 label$])
WHERE @7 is not null;

But it runs OK when I remove "WHERE @7 is not null".

Wed, 19 May 2010 04:26:41 GMT

Can u please send me the excel file and and your expected output on any excel file?

thanks

zaman

Wed, 19 May 2010 05:43:20 GMT

Try adding parenthesis in the WHERE... and using isNull()=0

WHERE (isNull(@7)=0)

Wed, 19 May 2010 06:27:13 GMT

Hi,

Try below one.

Where Len(@7)>0;

-Sridhar