Hi I’m having the exact same issue when merging two tables, I see you posted that the issue lays with the data and not the merge, can I ask how you solved it? I’m pretty sure I have unique values so I believe that is not the issue, actually the merge is working on someone else’s computer but not on mine. Appreciate any hint you may provide.
Sadly, I still have not been able to fix this problem with the "Merge" feature. I have resorted to using "Append" instead - and in some cases it works and in others it doesn't. It is a very frustrating situation.
I just ran into the same problem and fixed it by joining the two tables on multiple fields. For example, let's say a transaction number is the unique field you are joining on, expand the join to include other fields if possible. So your joins would be on transaction number, time, and amount.
Yes, that's what I've done too. However, even that solution created some duplicates as we don't have a one to one mappings in some cases. The only solution I could come up with (and one that would've slow down the query significantly) was to remove duplicates against the columns which then were used in merge. To make sure there's only one line per particular combination of columns. It's similar to how vlookup works. It brings up only the first occurrence for duplicates. However, since I'm new to PQ there might be things which I am not aware of. Thus waiting for some more experienced users to chip in.
I'm facing the same trouble here. Not sure why merging 2 tables create duplicates. Have anyone got a work around this?
Update 9/10 : Problem Solved. My original first table already have got unique rows hence I should have merged it as aggregated values otherwise it will further expand the table, causing duplicates. Also, it helps to use and select more than one field as the key to look up if you need that level of granularity.
Hi, I was having the same issue, and then I noticed that my second file, from where I was getting the data, had also duplicated figures. That was the problem. After I deleted those duplicates, I clicked on the refresh button, and the problem was solved!