Log In
Register
Home
New Member
January 19, 2023
Offline
Hello all,
After I have merged queries, Power Query has created duplicate rows for which it found a N/A. How to resolve this without editing any of my other data sets? Everything else is working just fine. Only need a resolution for this. Thanks in advance.
Moderators
January 31, 2022
Offline
It would be helpful if you could upload a file containing some data and the queries you have merged.
Don't forget to press "Start upload" before you submit your reply.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi FS,
The second table should have a single record for the keys used for merging. If 2 or more rows from the second table are matching the merge criteria, when you expand the merged tables this action will copy the first table record for all the rows found in second table.
Active Member
January 19, 2023
Offline
You should be using "The second table" which you say "a single record for the keys used for merging" as your primary file (top file in the Merge dialog window. The default Merge is a "Left Outer Join (all from first, matching from second)".
If for some reason you can't use the second table as the first merge table, change the Merge Type to "Right Outer (all from second, matching from first)".
You can use multiple columns as keys like both First Name and Last Name, but be sure you select them in the same order. If you select more than one key field, the order# will appear above the column header.
The other possibility is you have inaccurate keys in one or both files where the keys are different but the data is the same. There's no easy fix for that though!
1 Guest(s)
