Apply Map Function for IF conditions

[vidyasagar159]

Hello Every One,

I am using the following if condition in dimension expression.Since my data volume is more than 10Millions I am facing some performance issues.

=if(Match(CATEGORY,'Green Apples', 'Red Apples'),'Apples',

if(Match(CATEGORY,'Black Grapes','Green Grapes'),'Grapes',

if(Match(CATEGORY,'Green Mangos','Yelllow Mangos'),'Mangos','All other Fruits'

)))

Can you please suggest me how to increase the performance of using load script editor by using APPLYMAP() or any other alternative options?

Thanks,

-Vidya

[vidyasagar159]

Thanks, Sunny. This is really helpful.