topic Apply sql query operators in QlikView

Apply sql query operators

Mon, 12 Dec 2011 03:16:14 GMT

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.

sridhar240784 — Mon, 12 Dec 2011 04:11:06 GMT

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

Anonymous — Mon, 12 Dec 2011 05:42:15 GMT

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*');