Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a req like below.
If AREA value equal to LRM then i have to show LRM else go to AMR if in case both not satisfied then take AMR as per belwo input and output.How we can get in script level as well in dimension level or in expression level(set analysis is+ve)
Input:
AREA | LRM | AMR |
California | California | Siliconvalley |
US | UK | US |
INDIA | UK | US |
output:
California |
US |
US |
Thanks,
Ajay
I think I would do it in the script like
OutputTable:
LOAD
if(AREA = LRM, LRM, AMR) as OUTPUT
Resident InputTable;
Hi,
take a look at example app.
HTH
Roland
use like this
if(AREA=LRM, 'LRM','AMR')
Thanks both....its working. If in case that AREA field is coming from some other table and remaing 2 fields are coming from same table.
Then design level already sended script will work but how to do that in script level.
thanks,
ajay
in script
if(AREA=LRM, 'LRM','AMR') as Flag
Hi ajay,
if you have the fields in two different tables, plse send some adequate sample data as input. With this we should be able to build the script.
RR