Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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...
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...
Thanks Its working
You are welcome and glad able to help...
Enjoy your day...