Forum Discussion
DylanBanINT
Helper I
Helper ICombining two tables with same ID but different information
Hi, I have two tables which have have the same ID on them however one table combines more informationt than the other, I am looking to combine both into a new table but only show information if the I...
Use Merge as new from Merge Queries in Power query editor,
1.
2. Do join kind inner,
3. You will get your output,
Thanks,
Arul
Hi DylanBanINT ,
please make sure you selected the right fields (ID) and that they have the same data type. It must work if they have the same type and matching values.
If possible, could you share a screenshot of your data tables?
DylanBanINTHelper I
Helper IHi, so it seems with the specific information I'm using, that although I can go in and see that there are 100% matches from each column, when I try to merge it shows as no matches
Arul
Super User
Super User