topic How to use "like" query in QlikView Script? in QlikView

How to use "like" query in QlikView Script?

Thu, 28 Feb 2013 13:23:02 GMT

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

Thu, 28 Feb 2013 13:26:44 GMT

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 — Thu, 28 Feb 2013 13:31:11 GMT

Something like this:

load x,y,z from tablename

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

Thu, 28 Feb 2013 13:50:45 GMT

Yes, it worked perfectly. Thanks Gysbert

Thu, 28 Feb 2013 13:51:13 GMT

you can do this too

LOAD *

FROM YOUR_TABLE

WHERE FIELD_1 LIKE '*ar*ul*'

AND FIELD_2 NOT (LIKE '*mag*')