7 Replies Latest reply on Aug 20, 2018 10:32 PM by Naveen B

    Identify same data in different columns

    Suganthini Govindhasamy

      Hi, I'm first time to be here. Much appreciate your support!

       

      I have 4 columns as below.

      I need to check if all three 'Laptop, TV, Mobile'  have same segment. Example highlighted in red

       

      How can I get it in a calculated field? Please support.

       

      SEGMENTATIONSEGMENTATIONSEGMENTATION
      Customer ID#
      Laptop
      TV
      Mobile
      A123LargeLargeMedium
      A234MediumSmallSmall
      A678LargeLargeLarge
      A928SmallSmallSmall
      A564SmallLargeMedium
      A934MediumMediumMedium
      A256MediumMediumMedium