Finding Duplicate Data

Natasha van Graan shared this question ago

Answered

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

The same question

Replies (2)

Nathan Schroeder ●

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

Reply URL

Natasha van Graan ●

Hi Nathan

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

Thanks

Natasha

URL

Nathan Schroeder ●

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

Nathan

URL

Nathan Schroeder ●

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

Reply URL