Finding Duplicate Data

Natasha van Graan shared this question 6 years ago
Answered

Hi

I want to create a report to see how many, if any, duplicate transactions appear in my data source. How can I do that?


Absolutely no idea if is should use a calculated field, and if so, what is the calculation?

Duplicates should be shown if 1) date is the same, 2) document nr, 3) same amount.

Thanks in advance

Natasha

Replies (2)

photo
1

Hi Natasha,

If you include these three columns into the report, so that the data is grouped by these distinct values, then you should simply be able to include another column with "count" aggregate to show the total rows that match each of these three.

Let me know if this makes sense.

Regards,

Nathan

photo
1

Hi Nathan

Thank you for your reply. I will give it a try and let you know if it works.

Thanks

Natasha

photo
1

Sounds good, let me know if you run into problems.

Nathan

photo
photo
1

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!


Regards,

Nathan

Leave a Comment
 
Attach a file