Forum Discussion

DylanBanINT's avatar
DylanBanINT
Helper 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?

Ale's avatar
Ale
Resolver 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
Helper I
4 years ago

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