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?

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

Ale's avatar
Ale
Icon for Resolver II rankResolver II
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?

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

    THANK YOU! Completely forgot about needing them to be the same data type.