Forum Discussion
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 |
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,
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
1 Reply
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