Power Query, Merge, One-to-One, full outer join. Results are one-to-many join

[AnneMarie94]

Thanks for your help. In a single workbook, I have two tables (on separate worksheets) each as the same 14 columns. table 1 has 1276 rows, table 2 has 989 rows. I have connections to each table in the workbook queries list. I merged the queries with table 1 first then table 2. I selected the year columns first and then the country columns next. The merge editor said that 1274 rows matched for both columns. I asked for a full outer join and clicked Okay. Then in the Query Editor I expanded the rows for table 2. I selected all but one column which I knew had no data in it.

I could see in the Query Editor that this had not performed a one-to-one join. Instead it did a one-to-many join. Not only is this not what I wanted. But, it increased the size if the table exponentially. How can I get a one-to-one join. I'm pretty sure that I used this exact method two weeks ago to successfully join two other tables.

 

[sandy666]

Glad you solve it
Have a nice day