Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How to apply sql query in qlikview script?
LOAD *
FROM data.txt
(txt, codepage is 1252, embedded labels, delimiter is '|', msq);
I want to apply:
WHERE country not like A* ?
WHERE postcode <> '1100' AND postcode <> '2200'
How to combine into WHERE postcode <> '1100 2200' ?
Thanks in advance.
Hi,
You can use Not WildMatch() to do this.
Your code should like below.
LOAD *
FROM data.txt
(txt, codepage is 1252, embedded labels, delimiter is '|', msq)
Where Not WildMatch(postcode,'1100','2200') and Not WildMatch(country ,'A*');
Hope this helps you.
-Sridhar
Hi
we Can apply SQL Query in
SQL select statement
Which is used to fetech data from Database
and regarding Where clause
Where Not WildMatch(postcode,'1100','2200') and Not WildMatch(country ,'A*');