3 Replies Latest reply on Feb 26, 2018 6:03 PM by Shanker Raman

    Identify identical values in a partition

    Shanker Raman

      Hi!

       

      I have a dataset consisting of category and multiple dates within a category.

       

        

        

      CategoryDate
      Cat 14/19/2016
      Cat 23/18/2016
      3/20/2016
      3/27/2016
      4/30/2016
      Cat 33/19/2017
      3/19/2017
      4/20/2017
      9/12/2017
      4/1/2018
      Cat 43/20/2016
      4/25/2016
      5/20/2017
      9/12/2017

       

       

      I want to be able to create a calculated field using a table calculation or an LOD expression to identify those categories for whom there are identical dates. In the dataset above, cat 3 would have a True value, all the others would have a false value. Could somebody help? Thank you.