10 Replies Latest reply: Feb 9, 2016 12:59 PM by Mark Graham RSS

    If - Separating fields by its type

    Mark Graham

      Hi,

       

      I was trying to separate the IDs based on their type.

       

      The Type is associated with only Names. So, i wanna separate IDs based on the below logic:

       

      If any of the ID has Type A, then it falls under the A Category even though if it has a second name with B Category in it.

       

      ID falls into the Category B, only if it has name with just Type 'B'.

       

      ID,    Name,Type
      abcd,123,A
      abcd,456,B
      efgh,789,A
      ijkl,1011, B
      mnop,1213,A
      qrst,1415,B

       

       

      O/P:

       

      A Category IDs:

      abcd,

      efgh,

      mnop

       

      B Category IDs:

      ijkl,

      qrst



      Any help is highly appreciated.