not equal to wildmatch not working

[neerajthakur]

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?

[Raja2022 · Accepted solution]

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]

Thanks Its working

[Raja2022]

You are welcome and glad able to help...

Enjoy your day...