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
[TABLE="width: 352"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]date [/TD]
[TD]amount[/TD]
[TD]Table2.date[/TD]
[TD]Table2.amount[/TD]
[/TR]
[TR]
[TD="align: right"]2/10/2019[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]2/16/2019[/TD]
[TD="align: right"]7000[/TD]
[/TR]
[TR]
[TD="align: right"]2/17/2019[/TD]
[TD="align: right"]7000[/TD]
[TD="align: right"]2/16/2019[/TD]
[TD="align: right"]7000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2/9/2019[/TD]
[TD="align: right"]2500[/TD]
[/TR]
[TR]
[TD="align: right"]2/15/2019[/TD]
[TD="align: right"]7500[/TD]
[TD="align: right"]2/3/2019[/TD]
[TD="align: right"]7500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Amount[/TD]
[TD]Table2.Data[/TD]
[TD]Table2.Amount[/TD]
[/TR]
[TR]
[TD]02/10/19[/TD]
[TD]7000[/TD]
[TD]02/16/19[/TD]
[TD]7000[/TD]
[/TR]
[TR]
[TD]02/17/19[/TD]
[TD]7000[/TD]
[TD]02/16/19[/TD]
[TD]7000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]02/9/19[/TD]
[TD]2500[/TD]
[/TR]
[TR]
[TD]02/15/19[/TD]
[TD]7500[/TD]
[TD]02/3/19[/TD]
[TD]7500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Date[/td][td=bgcolor:#5B9BD5]Amount[/td][td][/td][td=bgcolor:#5B9BD5]Date[/td][td=bgcolor:#5B9BD5]Amount[/td][td][/td][td=bgcolor:#70AD47]Date[/td][td=bgcolor:#70AD47]Amount[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

10/02/2019​

[/td][td=bgcolor:#DDEBF7]

7000​

[/td][td][/td][td=bgcolor:#DDEBF7]

09/02/2019​

[/td][td=bgcolor:#DDEBF7]

2500​

[/td][td][/td][td=bgcolor:#E2EFDA]

03/02/2019​

[/td][td=bgcolor:#E2EFDA]

7500​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

15/02/2019​

[/td][td]

7500​

[/td][td][/td][td]

03/02/2019​

[/td][td]

7500​

[/td][td][/td][td]

09/02/2019​

[/td][td]

2500​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]

17/02/2019​

[/td][td=bgcolor:#DDEBF7]

7000​

[/td][td][/td][td=bgcolor:#DDEBF7]

16/02/2019​

[/td][td=bgcolor:#DDEBF7]

7000​

[/td][td][/td][td=bgcolor:#E2EFDA]

10/02/2019​

[/td][td=bgcolor:#E2EFDA]

7000​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

15/02/2019​

[/td][td]

7500​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]

16/02/2019​

[/td][td=bgcolor:#E2EFDA]

7000​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

17/02/2019​

[/td][td]

7000​

[/td][/tr]
[/table]

 

[sandy666]

or like this

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Amount[/td][td=bgcolor:#70AD47]Dates[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

7500​

[/td][td=bgcolor:#E2EFDA]03/02/2019, 15/02/2019[/td][/tr]

[tr=bgcolor:#FFFFFF][td]

2500​

[/td][td]09/02/2019[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]

7000​

[/td][td=bgcolor:#E2EFDA]10/02/2019, 16/02/2019, 17/02/2019[/td][/tr]
[/table]