5 Replies Latest reply on Oct 28, 2018 11:48 AM by Daniel Quek

    Checking Claim Duplication with +/- $1 difference

    Daniel Quek

      Hi, I have the list of claims below which I would like to pick only those records with the same Name/Start Date/End Date and claim amounts that are same or with $1 difference.

       

      Is there a way to do it in Tableau Prep or Tableau itself?

       

      NameStart DateEnd DateClaim Amount
      Albert29/10/183/11/18$2
      Albert29/10/183/11/18$3
      Ben31/10/183/11/18$3
      Cherry28/10/185/11/18$2
      Daniel29/10/184/11/18$1
      Daniel29/10/184/11/18$5
      Tom30/10/184/11/18$2
      Tom30/10/184/11/18$2