topic Re: Loading Data From The DB using Scripts in QlikView

Loading Data From The DB using Scripts

anuradhaa — Thu, 18 Oct 2012 16:30:01 GMT

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

MayilVahanan — Thu, 18 Oct 2012 16:36:32 GMT

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 — Thu, 18 Oct 2012 16:48:21 GMT

No, Not Works

MayilVahanan — Thu, 18 Oct 2012 17:09:09 GMT

Try like this,

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

Select YYY,XXX from tablename;

Hope that helps