Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
176
Views
Topic starter
Hi,
apologies again if this is already answered.
When merging the two data sets do they have to have the same column headings - if there are additional columns of data contained in only one data set - when the merge is complete will Power Query add these additional columns on the end of the resulting data set.
Thank you for your help,
Murray
Posted : 28/11/2020 11:39 am
Hi Murray,
I suspect you are confusing merging with appending. Appending is similar to copying and pasting data sets one below another. For this the column headers need to be the same in each dataset.
Merging in Power Query is more like performing a VLOOKUP from one table to the next. For that the column headers can be different.
Mynda
Posted : 29/11/2020 12:16 am
