topic Re: Combine many Where Clauses into one in script? in QlikView

Combine many Where Clauses into one in script?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have been trying for days now to write these parameters into my script with no luck. I keep searching but can’t find anything that works. Your time and help is gratefully appreciated.

I’m trying to load the following script, but I need a way to combine the Where clause into one. I can run them all independently, but can’t seem to figure a way to combine them.

LOAD

[Code],

[Diagnosis Date & Time],

[Medical Service],

Organization,

[Person Alias]

FROM

(ooxml, embedded labels, header is 3 lines, table is [Report 1])

Where Match(Left([ICD10 Diagnosis Code],1),'D')

Where Match(Left([ICD10 Diagnosis Code],3),'C44')

Where Match(Left([ICD10 Diagnosis Code],4),'R856',’R876’)

Then I have a list of codes that I need to exclude: ('C443.2', ‘C449.32’,'D01.0', ‘D03.4’)

Re: Combine many Where Clauses into one in script?

MarcoWedel — Tue, 30 Jan 2018 22:56:15 GMT

Where WildMatch([ICD10 Diagnosis Code],'D*','C44*','R856*',’R876*’) and not Match([ICD10 Diagnosis Code],'C443.2', ‘C449.32’,'D01.0', ‘D03.4’)

hope this helps

regards

Marco

Re: Combine many Where Clauses into one in script?

MarcoWedel — Tue, 30 Jan 2018 22:58:54 GMT

or another one using your expressions:

Where (Match(Left([ICD10 Diagnosis Code],1),'D') or Match(Left([ICD10 Diagnosis Code],3),'C44') or Match(Left([ICD10 Diagnosis Code],4),'R856',’R876’)) and not Match([ICD10 Diagnosis Code],'C443.2', ‘C449.32’,'D01.0', ‘D03.4’)

Re: Combine many Where Clauses into one in script?

Anonymous — Tue, 30 Jan 2018 23:05:09 GMT

This worked like a charm! Thank you so much Marco!