topic join and where loading data in QlikView

join and where loading data

Tue, 03 Apr 2012 17:59:54 GMT

Hi everyone,

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

deal_externals:

load

xx,

bac_id

from deal_externals.qvd

where bac_id is not null;

left join

deals:

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.

Re: join and where loading data

rwunderlich — Tue, 03 Apr 2012 18:31:54 GMT

where not IsNull(bac_id)

where len(bac_id)>0

-Rob

Re: join and where loading data

Tue, 03 Apr 2012 18:38:38 GMT

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