topic Re: Exclusions in the script in QlikView

Exclusions in the script

Tue, 29 Apr 2014 14:32:51 GMT

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!

Re: Exclusions in the script

MK_QSL — Tue, 29 Apr 2014 14:43:06 GMT

Load * From TableName

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

Re: Exclusions in the script

its_anandrjs — Tue, 29 Apr 2014 14:49:39 GMT

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

Re: Exclusions in the script

its_anandrjs — Tue, 29 Apr 2014 14:54:23 GMT

Load your table like

LOAD

From Location

Where not index( patients , 'integration' );

Re: Exclusions in the script

its_anandrjs — Tue, 29 Apr 2014 15:13:47 GMT

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

Re: Exclusions in the script

Tue, 29 Apr 2014 15:17:51 GMT

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