10 Replies Latest reply: Feb 14, 2018 3:10 PM by vidya sagar malla RSS

    Apply Map Function for IF conditions

    vidya sagar malla

      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