Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Apply sql query operators

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.

Tags (1)
2 Replies
sridhar240784
Contributor III

Apply sql query operators

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

sach_sahu1
New Contributor III

Apply sql query operators

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

Community Browser