topic Re: How to use Wildcard Not Like Match in QlikView

How to use Wildcard Not Like Match

Wed, 08 Apr 2015 17:26:32 GMT

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?

Re: How to use Wildcard Not Like Match

sunny_talwar — Wed, 08 Apr 2015 17:54:58 GMT

Try this:

TableName:

LOAD yourFields,

field1

From xyz.qvd

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

Best,

Sunny

Re: How to use Wildcard Not Like Match

Anonymous — Wed, 08 Apr 2015 18:09:46 GMT

... or:

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

Re: How to use Wildcard Not Like Match

sunny_talwar — Wed, 08 Apr 2015 18:11:01 GMT

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

Best,

Sunny

Re: How to use Wildcard Not Like Match

Anonymous — Wed, 08 Apr 2015 18:12:19 GMT

Same thing, just a personal preference.

Re: How to use Wildcard Not Like Match

sunny_talwar — Wed, 08 Apr 2015 18:13:45 GMT

Great, thanks for pointing that out

Re: How to use Wildcard Not Like Match

rwunderlich — Wed, 08 Apr 2015 21:44:34 GMT

You can also write it as:

where not field1 like '*HEB*'

-Rob

Re: How to use Wildcard Not Like Match

Anonymous — Thu, 09 Apr 2015 00:01:06 GMT

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.

Re: How to use Wildcard Not Like Match

Thu, 09 Apr 2015 11:50:25 GMT

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*'
;

Re: How to use Wildcard Not Like Match

sunny_talwar — Thu, 09 Apr 2015 11:55:25 GMT

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