Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
No, Not Works
Hi
Try like this,
Load *,AUTONUMBER(XXX & '-' & YYY) AS key where YYY <> 'C' and YYY <> 'B';
Select YYY,XXX from tablename;
Hope that helps