Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
neerajthakur
Creator III
Creator III

not equal to wildmatch not working

LOAD stateid,
statename,
// status,
// create_date,
// modify_date,
statesvgid
FROM
[C:\Users\NeerajKumar\Geography\state.qvd]
(qvd) where statename <> WildMatch(statename,'har','hjkhjhjj','hp','sahdfjkh','rajasthan1');

 

I am trying to exclude the names mentioned in list from overall but I am still getting them. How can I fix this issue?

Thanks & Regards,
Please Accepts as Solution if it solves your query.
Labels (4)
1 Solution

Accepted Solutions
Raja2022
Contributor III
Contributor III

Please give a try on the below:

Change as below:

From:

FROM
[C:\Users\NeerajKumar\Geography\state.qvd]
(qvd) where statename <> WildMatch(statename,'har','hjkhjhjj','hp','sahdfjkh','rajasthan1');

To:

FROM
[C:\Users\NeerajKumar\Geography\state.qvd]
(qvd) where NOT <> WildMatch(statename,'har','hjkhjhjj','hp','sahdfjkh','rajasthan1');

 

Here is a sample code that works as an example:

Data:
Load * Inline [
statename
rajasthan
chennai
mysore
calcutta
pune
delhi
haryana

];

NoConcatenate
Final:
load *
Resident Data
where NOT WildMatch(statename,'delhi','rajasthan');

drop table Data;

Hope this helps...

View solution in original post

3 Replies
Raja2022
Contributor III
Contributor III

Please give a try on the below:

Change as below:

From:

FROM
[C:\Users\NeerajKumar\Geography\state.qvd]
(qvd) where statename <> WildMatch(statename,'har','hjkhjhjj','hp','sahdfjkh','rajasthan1');

To:

FROM
[C:\Users\NeerajKumar\Geography\state.qvd]
(qvd) where NOT <> WildMatch(statename,'har','hjkhjhjj','hp','sahdfjkh','rajasthan1');

 

Here is a sample code that works as an example:

Data:
Load * Inline [
statename
rajasthan
chennai
mysore
calcutta
pune
delhi
haryana

];

NoConcatenate
Final:
load *
Resident Data
where NOT WildMatch(statename,'delhi','rajasthan');

drop table Data;

Hope this helps...

neerajthakur
Creator III
Creator III
Author

Thanks Its working

Thanks & Regards,
Please Accepts as Solution if it solves your query.
Raja2022
Contributor III
Contributor III

You are welcome and glad able to help...

Enjoy your day...