Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
try this one.
load *
where match(Cust,'BC','NNN','NDS')=0;
load * inline [
Cust
A
BC
NDS
DEF
];
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
];
Are you Looking for Matheson Gas Login then check here Matheson Gas Login Official portal.
Very good, I think I found the knowledge I needed. I will see and refer to some information in your post. thank you!
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
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/