3 Replies Latest reply on Oct 22, 2017 4:59 AM by Norbert Maijoor

    Mark first distinct/unique value in a column as Y

    Faiz Mohd

      Hello Tableau Group ,

      I have data in my table as shown below. The column Name has values which repeats itself.

         

      IDNameUnique Flag
      1MarkY
      2PeterY
      3JaneY
      4MaryY
      5PeterN
      6JohnY
      7JennyY
      8PeterN
      9MaryN
      10JennyN

      I need to create a custom field "Unique Flag" which should be calculated as  -- "Lookup for value in the same column  Name and if the Value appears once Mark it as "Y" , If it appears multiple times , then mark the first instance of the value as "Y" and others as "N".

       

      Any help is greatly appreciated..

       

      Thanks

      Faiz