join and where loading data

[#1]

Hi everyone,

      im trying to run a script with "left join" and "where" like this

deal_externals:

load

xx,

xx,

xx,

bac_id

from deal_externals.qvd

where bac_id is not null;

left join

deals:

x,

x,

x

from deals.qvd;

But there is something wrong in the syntax with "where" condition:

this is the error: Garbage after statement

Could you help me to write the "where" condition in the right way.

Thanks.

[rwunderlich · Accepted solution]

where not IsNull(bac_id)

or

where len(bac_id)>0

-Rob

[#3]

Thanks!

De: Rob Wunderlich

Enviado el: martes, 03 de abril de 2012 03:32 p.m.

Para: Pauza, Gerardo

Asunto: - Re: join and where loading data

QlikCommunity <http://community.qlik.com/index.jspa>

Re: join and where loading data

created by Rob Wunderlich <http://community.qlik.com/people/robwunderlich> in New to QlikView - View the full discussion <http://community.qlik.com/message/207115#207115