Duplicating values in a table after union with additional table

Question

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 Answer

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?