cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zakaria_1980
Helper V
Helper V

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 NbPjt Nam.CaseIdCity
XXXXXXXXXXXXXXXXX

 

in the 2nd  tbl, i've the following inputs:

Opporty NbCreation_dateSubmission_dateApproval_date
XXXX/XX/XXXXXX/XX/XXXXXX/XX/XXXX

 

let's say that i want the following output:

 

Opporty NbPjt Nam.Creation_dateSubmission_dateApproval_date
XXXXXXXX/XX/XXXX XX/XX/XXXXXX/XX/XXXX

 

when i make the relatioship bw the two tbls by "Opporty Nb", i get my output tbl empty, whether i used the Opportyns Nb from tbl1 or Tbl2.

 

Thanks for your help to understand where is my error.

 

regards,

 

1 ACCEPTED SOLUTION
goncalogeraldes
Super User
Super User

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"). 

goncalogeraldes_1-1643190096479.png

 

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

goncalogeraldes_2-1643190182144.png

 

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

 

 

 

View solution in original post

1 REPLY 1
goncalogeraldes
Super User
Super User

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"). 

goncalogeraldes_1-1643190096479.png

 

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

goncalogeraldes_2-1643190182144.png

 

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

 

 

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!