Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Something like this:
load x,y,z from tablename
where wildmatch(column_name1, '*ar*ul*') and not wildmatch(column_name2, '*mag*');
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%'
Something like this:
load x,y,z from tablename
where wildmatch(column_name1, '*ar*ul*') and not wildmatch(column_name2, '*mag*');
Yes, it worked perfectly. Thanks Gysbert
you can do this too
LOAD *
FROM YOUR_TABLE
WHERE FIELD_1 LIKE '*ar*ul*'
AND FIELD_2 NOT (LIKE '*mag*')