Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
where not IsNull(bac_id)
or
where len(bac_id)>0
-Rob
Thanks!
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