4 Replies Latest reply on Oct 6, 2016 5:24 AM by Mahfooj Khan

    Comparing multiple rows to flag duplicate payments

    RITESH TIBREWAL

      Hi,

       

      I am trying hard to find a way to Flag rows with same "vendor number + Payment date + Amount paid".

       

      Here is a sample data set:

       

      Invoice Number
      Vendor Number
      Payment Date
      Amount Paid
      1245611210/10/201645000
      1445014223/10/201690000
      3213211210/10/201645000
      2340811210/10/201645000
      5600314223/10/201634000

       

      For this data, in Tableau I want this output:

       

      Invoice number

      Invoice Number
      12456
      32132
      23408

       

      Please help !!

       

      Thanks,

      Ritesh