Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone-
I am trying exclude all of the test patients we have loaded in one of our patient table.
I would like to exclude all of the patients that have "integration" as part of their name. There are about 50-60 Test Patients with "integration" in their name. What would be the best way to exclude them in the script?
Thanks!
Load * From TableName
Where NOT WILDMATCH(Patients,'*integration*');
The word integration is in and particular length or any position or it is random.
Load your table like
LOAD
*
From Location
Where not index( patients , 'integration' );
Did you check my solution also it is correct or not check once and let me know that.
I did not check it, as the first response I received was a solution that worked.