How to use Wildcard Not Like Match

[#1]

I need to exclude data after loading the QVD within the load script. I am unsure of the proper syntax.

ex: where field1 not like '*HEB*'

How would I write this? Does it occur after the QVD is loaded?

[sunny_talwar]

Try this:

TableName:

LOAD yourFields,

          field1

From xyz.qvd

Where not WildMatch(field1, '*HEB*');

Best,

Sunny

[Anonymous]

... or:

WHERE WildMatch(field1, '*HEB*')=0

[sunny_talwar]

Michael Solomovich‌ is one of them better than the other? or they essentially the same thing?

Best,

Sunny

[Anonymous]

Same thing, just a personal preference.

[sunny_talwar]

Great, thanks for pointing that out

[rwunderlich]

You can also write it as:

where not field1 like '*HEB*'

-Rob

[Anonymous]

Rob,

I often use "like" in SQL but never in QlikView script.  In this case it matches the thread title nicely, I'd recommend lindsayyurchick‌ to choose your response as the correct one.

[#9]

Thank you all! The next issue is that I have multiple 'where' statements and I'm unsure how to string them together in the load script. The below syntax is not working

(qvd)
where Not match(LEVEL_02,'No', 'DISCONTINUED' , 'UNIT LOAD') and
where not LEVEL_02 like '*HEB*' and
where not Level_01 like '*HEB*'
;

[sunny_talwar · Accepted solution]

You don't need multiple Where, try like this:

(qvd)
where not WildMatch(LEVEL_02,'No', 'DISCONTINUED' , 'UNIT LOAD', '*HEB*') and not WildMatch(Level_01, '*HEB*');

HTH

Best,

Sunny