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

Comparing multiple rows to flag duplicate payments

RITESH TIBREWAL Oct 6, 2016 3:12 AM

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
12456	112	10/10/2016	45000
14450	142	23/10/2016	90000
32132	112	10/10/2016	45000
23408	112	10/10/2016	45000
56003	142	23/10/2016	34000

For this data, in Tableau I want this output:

Invoice number

Please help !!

Thanks,

Ritesh

1. Re: Comparing multiple rows to flag duplicate payments

Mahfooj Khan Oct 6, 2016 4:24 AM (in response to RITESH TIBREWAL)

You can try this. Put this cacl field on filters shelf and select "True".
Hope this is what you wanted.

Mahfooj
3 of 3 people found this helpful
Like Show 2 Likes(2)

Actions
2. Re: Comparing multiple rows to flag duplicate payments

Norbert Maijoor Oct 6, 2016 4:40 AM (in response to RITESH TIBREWAL)

Hi Ritesh,

Find my approach based on LOD-expressions and stored at Tableau Public here
Please test approach on bigger dataset to be sure all different scenario's are covered.

a. LOD expression: Count amount of invoice per Vendor

b. LOD expression: Total amount per Vendor

c. Calculation "Flag no flag"

Hope it helps...

Have a nice day.
Like Show 1 Likes(1)

Actions
3. Re: Comparing multiple rows to flag duplicate payments

RITESH TIBREWAL Oct 6, 2016 4:45 AM (in response to Mahfooj Khan)

That's exactly what I wanted.
Thanks a lot Mahfooj !!
Like Show 0 Likes(0)

Actions
4. Re: Comparing multiple rows to flag duplicate payments

Mahfooj Khan Oct 6, 2016 5:24 AM (in response to RITESH TIBREWAL)

Kindly close the thread by marking my answer as correct so that it can help others who have similar query.
Like Show 0 Likes(0)

Actions