Loading Data From The DB using Scripts

[anuradhaa]

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]

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]

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