Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

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
MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
anuradhaa
Partner - Creator II
Partner - Creator II
Author

No, Not Works

MayilVahanan

Hi

Try like this,

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

Select YYY,XXX from tablename;

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.