Neglecting subcategory after uploading data

[aboxhammer]

Hi there,

I need to provide a table with schedulers and their products, but my excel data base contains schedulers from other units I need to exclude without changing the excel file.

When using if or wildmatch in the table collums my whole column shows no values.

Is there an easy way to

1) make qlik neglect those schedulers I dont need after loading the data, like an if or filter function in the data preparation?

Thanks a lot and stay healthy

Andi

[edwin · Accepted solution]

match should work esp if you know which ones specifically to include or exclude.  try this (it will retain anything not in the list):

load *
where match(Cust,'BC','NNN','NDS')=0;
load * inline [
Cust
A
BC
NDS
DEF
];

[preetipriti · Accepted solution]

try this one.

load *
where match(Cust,'BC','NNN','NDS')=0;
load * inline [
Cust
A
BC
NDS
DEF
]; 

Mcdvoice

[Jasereze3]

Are you Looking for Matheson Gas Login then check here Matheson Gas Login Official portal.

[Blackjonh]

Very good, I think I found the knowledge I needed. I will see and refer to some information in your post. thank you!

Click Here

[mewab50087]

MyHealth Plan Account, which can significantly help individuals take control of their health-related expenses and make informed financial decisions.
https://www.diigo.com/item/note/ahpg9/yi3j?k=7ce125c3a5cb64a4ca25030380ba2da2

[Nderfdrdsrcs]

In this article, we will delve into the various aspects of how MyMercy Login  is transforming patient-centric care. From personalized treatment plans to seamless access to medical information, MyMercy is setting new standards for the healthcare industry. https://gaatz-ploialls-hyauently.yolasite.com/