Link two tbls

[Zakaria_1980]

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

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

Opporty Nb	Creation_date	Submission_date	Approval_date
XX	XX/XX/XXXX	XX/XX/XXXX	XX/XX/XXXX

let's say that i want the following output:

Opporty Nb	Pjt Nam.	Creation_date	Submission_date	Approval_date
XX	XXXX	XX/XX/XXXX	XX/XX/XXXX	XX/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,

[goncalogeraldes · Accepted solution]

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