Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use "like" query in QlikView Script?

Hi,

I have an SQL query as " select x,y,z from tablename where column_name like '%ar%ul%' "

How to write the above query in Qlikview Script?

Any help is greatly appreciated

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Something like this:

load x,y,z from tablename

where wildmatch(column_name1, '*ar*ul*')  and not wildmatch(column_name2, '*mag*');


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Not applicable
Author

Sorry, a small addition to the above query -- select x,y,z from tablename where column_name1 like '%ar%ul%'  and column_name2 not like '%mag%'

Gysbert_Wassenaar

Something like this:

load x,y,z from tablename

where wildmatch(column_name1, '*ar*ul*')  and not wildmatch(column_name2, '*mag*');


talk is cheap, supply exceeds demand
Not applicable
Author

Yes, it worked perfectly. Thanks Gysbert

Not applicable
Author

you can do this too

LOAD *

FROM YOUR_TABLE

WHERE FIELD_1 LIKE '*ar*ul*'

      AND FIELD_2 NOT (LIKE '*mag*')