Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

using "like" in the script

I'm trying to use the "like" operator in my load script to limit what date is fed into my QlikView application...For example...


LOAD
Id as PersonId,
Name as PersonName,
Address as PersonAddress
FROM DataFile.csv
WHERE Address like 'Street';


That is, I only want to load data that has the string "Street" somewhere in the Address field. If that string does not exist in the Address field, do not load that data row. I tried using the "like" operator in the script with no luck. Any ideas?

Tags (2)
1 Solution

Accepted Solutions
Honored Contributor II

using "like" in the script

... WHERE WILDMATCH(Address, '*Street*') ...

-- please note the apostrophs

HTH
Peter

View solution in original post

2 Replies
Honored Contributor II

using "like" in the script

... WHERE WILDMATCH(Address, '*Street*') ...

-- please note the apostrophs

HTH
Peter

View solution in original post

Highlighted
Not applicable

using "like" in the script

Excellent...many thanks!