Exclusions in the script

[#1]

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!

[MK_QSL · Accepted solution]

Load * From TableName

Where NOT WILDMATCH(Patients,'*integration*');

[its_anandrjs]

The word integration is in and particular length or any position or it is random.

[its_anandrjs]

Load your table like

LOAD

*

From Location

Where not index( patients , 'integration' );

[its_anandrjs]

Did you check my solution also it is correct or not check once and let me know that.

[#6]

I did not check it, as the first response I received was a solution that worked.