Apply sql query operators

[#1]

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]

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]

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