ASK.. Simple Syntax in edit script and expression

[#1]

heelo all,

need help plis , thankss

what is syntax of "not in" or "in"??

example,

load

...

...

...

from ..... where status = 1;

and now i want to load where status is "in" or "not in" 1,2,3,

what is the syntax?

load

...

...

...

from .... where status NOT IN ('1','2','3'); <----- is that right??

or

from .... where status IN ('1','2','3'); <----- is that right??

plis correct me..

and in expression

usually like this,

SUM({<Status = {'1'}>}Sales)

same question,

what is the syntax of "not in" in expression??

thank you...

best regards!!

[#2]

Hi Frozenring,

You can use the script as follows,

load

...

...

...

from ..... where status <> 1;

Regards!!!

Nilupa

[suniljain · Accepted solution]

You can use

where (Status='1' or Status = '2' or Status ='3') ) ;

[#4]

hello sunin..

then what is not in??

hello nilupaboralessa,

how to use if not in more than 1?

and what is the syntax not equal or not in , in expression??

thank you all

[#5]

Hello Frozenring,

You can use as

...................WHERE STATUS<>1 OR STATUS<>2 OR STATUS<>3

Nilupa

[Miguel_Angel_Baeyens]

Hello Frozenring,

If you are loading from a QVD file, or you just don't want the server to do the job, I'd rather use for simplicity sake, the "match()" function for IN:

LOAD * FROM FILE.QVD (qvd)WHERE MATCH(STATUS, 1, 2, 3) > 1;

or NOT IN

LOAD * FROM FILE.QVD (qvd)WHERE MATCH(STATUS, 1, 2, 3) = 0;

Hope this helps

[#7]

thank you miguel,

best regards!