2 Replies Latest reply on Nov 1, 2018 12:17 PM by Venkat S

    Create multi-category field from same value(s)

    Venkat S

      Hi All,

       

      I am trying to create product groups but unable to create same.

       

      I tried using both CASE and IF functions but both giving same result.

       

      Here is case script:

       

      CASE [Product]

      WHEN "Product A" THEN "Group 1"

      WHEN "Product A" THEN "Group 2"

      WHEN "Product B" THEN "Group 1"

      WHEN "Product B" THEN "Group 2"

      WHEN "Product C" THEN "Group 1"

      WHEN "Product C" THEN "Group 2"

      WHEN "Product D" THEN "Group 1"

      WHEN "Product D" THEN "Group 2"

      END

       

      Thank you!