Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavvibudagam
Creator II
Creator II

How to remove record from the field

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.

3 Replies
its_anandrjs
Champion III
Champion III

Can you share any sample data.

its_anandrjs
Champion III
Champion III

May be this you can

TableA:

Load

Data,

ID,

Country,

State

From ....

Where Not Match(Country,'Japan') and Not Match(State,'Tokyo');

OmarBenSalem

maybe :

TableA:

Load

Data,

ID,

Country,

State

From .... where Country <>'Japan';