Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Try this:
TableName:
LOAD yourFields,
field1
From xyz.qvd
Where not WildMatch(field1, '*HEB*');
Best,
Sunny
... or:
WHERE WildMatch(field1, '*HEB*')=0
Michael Solomovich is one of them better than the other? or they essentially the same thing?
Best,
Sunny
Same thing, just a personal preference.
Great, thanks for pointing that out
You can also write it as:
where not field1 like '*HEB*'
-Rob
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.
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*'
;
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