Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
I currently have this LOAD statment:
LOAD
ID,
AGE,
ESP,
...
FROM [] WHERE AGE>0 and AGE<120 and IF(ESP=('1') or ESP=('2') or ESP=('3') or ESP=('4') or ESP=('5') or ESP=('6') or ESP=('7') or ESP=('8') or ESP=('19') or ESP=('20') or ESP=('21') or ESP=('22') or ESP=('23') or ... ,'ok')='ok';
Is there any way to substitute this bunch of OR for something more elegant or less process-consuming?
Hi there,
There is a cool material here: If Tips by Rob Wunderlich
Regards
You could replace your IF(ESP=('1').... expression with a Match() statement like this
WHERE AGE>0 and AGE<120 AND Match(ESP,1,2,3,4,5,6,7,8,19,20,21,22,23)
Hi there,
There is a cool material here: If Tips by Rob Wunderlich
Regards
You could replace your IF(ESP=('1').... expression with a Match() statement like this
WHERE AGE>0 and AGE<120 AND Match(ESP,1,2,3,4,5,6,7,8,19,20,21,22,23)
Thanks!
Thanks! I used exactly this