Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

join and where loading data

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: join and where loading data

where not IsNull(bac_id)

or

where len(bac_id)>0

-Rob

2 Replies
MVP & Luminary
MVP & Luminary

Re: join and where loading data

where not IsNull(bac_id)

or

where len(bac_id)>0

-Rob

Not applicable

Re: join and where loading data

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