Forum Discussion

DylanBanINT's avatar
DylanBanINT
Icon for Helper I rankHelper I
4 years ago
Solved

Combining 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...
Need Help
  • Arul's avatar
    Arul
    4 years ago

    DylanBanINT ,

    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

     

     



  • Ale's avatar
    Ale
    4 years ago

    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?

Arul's avatar
Arul
Icon for Super User rankSuper User
4 years ago

DylanBanINT ,

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

 

 



  • DylanBanINT's avatar
    DylanBanINT
    Icon for Helper I rankHelper I
    4 years ago

    Hi, 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's avatar
      Arul
      Icon for Super User rankSuper User
      4 years ago

      DylanBanINT ,

      Can you brief it more or show us what you got?