Duplicating values in a table after union with additional table

[NickO117]

I have two tables that I am attempting to join with a union. However, I am getting a duplicate record in one table for every record in the second table.

Is there any way to eliminate this and only have unique rows in each table?

Output is shown below; the table with aging buckets is the table I would like to display only a single unique record.

[putu_w_erata · Accepted solution]

Union between two tables should not result in duplicates unless there are already duplicates in your tables. I can't see any duplicates from your sample data, can you show us the actual data? 

In any case can you just use "Unique" tool to remove the duplicates?

[NickO117]

You are correct,

I used a formula to calculate and append the total to each record.

I used a unique filter before my table, and it corrected the error.

Thank you for pointing me in the right direction.