Duplicate Data

[anillinda]

I am merging 2 databases and joining through using the data in the amount column, on table 1 there are a few entries that have duplicate amounts, when the query is merged the power query matches

table 1

Date Amount
02/10/19 7000
02/15/19 7500
02/17/19 7000
table 2
date Amount
02/9/19 2500
02/3/19 7500
02/16/19 7000

date	amount	Table2.date	Table2.amount
2/10/2019	7000	2/16/2019	7000
2/17/2019	7000	2/16/2019	7000
		2/9/2019	2500
2/15/2019	7500	2/3/2019	7500

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

The merged table matched two amounts of 7000/- from table 1 to 2 entries from table 2, where there was only one $7000/- entry which is wrong. The merge was done using all rows from both tables.
How can I correct this error?
Thanks
Neal

Date	Amount	Table2.Data	Table2.Amount
02/10/19	7000	02/16/19	7000
02/17/19	7000	02/16/19	7000
		02/9/19	2500
02/15/19	7500	02/3/19	7500

<tbody>
</tbody>

 

[sandy666]

what you want to achieve?
any example of the result?

 

[anillinda]

I do not want duplicate entries in the merged table

 

[sandy666]

maybe join tables via APPEND feature?

Date	Amount		Date	Amount		Date	Amount
10/02/2019​	7000​		09/02/2019​	2500​		03/02/2019​	7500​
15/02/2019​	7500​		03/02/2019​	7500​		09/02/2019​	2500​
17/02/2019​	7000​		16/02/2019​	7000​		10/02/2019​	7000​
						15/02/2019​	7500​
						16/02/2019​	7000​
						17/02/2019​	7000​

 

[sandy666]

or like this

Amount	Dates
7500​	03/02/2019, 15/02/2019
2500​	09/02/2019
7000​	10/02/2019, 16/02/2019, 17/02/2019