Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on this.
TableA:
Load
Data,
ID,
Country,
State
From ....
In the above table Country field contains 5 countries out of 5 countries I have to remove Japan record from country field and from State I have to remove Tokyo record from 5 states.
The filtering need to be done at only field level in the back end script only not at data level.
Please suggest me to proceed.
Thanks in advance.
Can you share any sample data.
May be this you can
TableA:
Load
Data,
ID,
Country,
State
From ....
Where Not Match(Country,'Japan') and Not Match(State,'Tokyo');
maybe :
TableA:
Load
Data,
ID,
Country,
State
From .... where Country <>'Japan';