5 Replies Latest reply: Nov 2, 2017 9:51 AM by Sunny Talwar RSS

    if condition with same value

    Priya R

      hi Community,

       

      I am finding the way to create 2 different attributes with same value like below.

       

      Dim1

      A

      B

      C

      D

      E

      F

       

       

      I am trying to create below condition based on above data(Dim1)

      if(match(Dim1,'A','B','C','D'),'Cons',

      if(match(Dim1,'A','B'),'AB_Cons')) as Cons_Filter

       

      I want both to be populated Cons and 'AB_Cons' under Cons_Filter but values are filter first level itself so I am getting only 'Cons'.

      Can someone please help if we have any work around to get desired values.

       

      _priya