
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to use Wildcard Not Like Match
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?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
TableName:
LOAD yourFields,
field1
From xyz.qvd
Where not WildMatch(field1, '*HEB*');
Best,
Sunny

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
... or:
WHERE WildMatch(field1, '*HEB*')=0

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Michael Solomovich is one of them better than the other? or they essentially the same thing?
Best,
Sunny

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Same thing, just a personal preference.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great, thanks for pointing that out


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can also write it as:
where not field1 like '*HEB*'
-Rob

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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*'
;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
