Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
anuradhaa
Contributor

Loading Data From The DB using Scripts

In My scrip i have,

AUTONUMBER(XXX & '-' & YYY) AS YYY,

in my DB YYY has values (A,B,C,D,E)

then i want to remove C and D form the data when i'm loading Data.

Then i use below SQL,

In MY where Clause

YYY NOT IN ('C','D')

but when i load data i can see all the values.

What's the wrong with my scrip

Thanks

3 Replies

Re: Loading Data From The DB using Scripts

HI

I think

AUTONUMBER(XXX & '-' & YYY) AS YYY

So, YYY values not as C,B.. its combines x value - y value .

Try like this

AUTONUMBER(XXX & '-' & YYY) AS key. and use where clause as YYY not in ('C','D')

hope that helps

anuradhaa
Contributor

Re: Loading Data From The DB using Scripts

No, Not Works

Re: Loading Data From The DB using Scripts

Hi

Try like this,

Load *,AUTONUMBER(XXX & '-' & YYY) AS key where YYY <> 'C' and YYY <> 'B';

Select YYY,XXX from tablename;

Hope that helps

Community Browser