Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
4 years ago
Solved

Link two tbls

Hello,   i've two tables and the main data in both tbls is "Opporty Nb".  in the first tbl, i've the following inputs:   Opporty Nb Pjt Nam. CaseId City XX XXXX XXXXXX XXXXX   i...
Need Help
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    Hello there Zakaria_1980 ! Have you tried to do it with a Merge in Power Query? You can do so by using the "Merge Queries" option in the Home tab on Power Query and then selecting the common column (in your case "Opporty Nb"). 

     

    After this step you can selected which columns to expand (keep) in your merge:

     

    You can also remove any unnecessary column from the left of the merge to ultimately get the result you need! 

     

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes

     

     

     

goncalogeraldes's avatar
goncalogeraldes
Super User
4 years ago

Hello there Zakaria_1980 ! Have you tried to do it with a Merge in Power Query? You can do so by using the "Merge Queries" option in the Home tab on Power Query and then selecting the common column (in your case "Opporty Nb"). 

 

After this step you can selected which columns to expand (keep) in your merge:

 

You can also remove any unnecessary column from the left of the merge to ultimately get the result you need! 

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes