set analysis in loading script

[souadouert]

     Hello,

i neeed to know if i can uses set expression in load statement for example  Have _exp Variable

SALES :

load

PRODUCT,SALES from SALE;

product:

PRODUCT, name ,from products

let  _exp ='sum({< PRODUCT={'P1'}>}1)';

let _name='EXP1'

LOAD

* ,

'$(_exp )' as  $(_name)

RESIDENT product

[Or]

There is no set analysis in script. You'll have to use good, old-fashioned conditional statements like if().

[YoussefBelloum]

Hi,

no set expressions on script, but for the _exp variable ='sum({< PRODUCT={'P1'}>}1)'; you can try this:

table:

load

.

if(PRODUCT='P1', 1) as SUM

.

.

group by

all fields except SUM