Forum Discussion
Merging Rows with Common ID from different Tables
Hi all,
I have three tables of the form:
| ID | Location |
| 11 | NY |
| 12 | DL |
| 13 | IN |
| 14 | TX |
| 17 | NY |
| ID | Weight |
| 11 | 1 |
| 12 | 2 |
| ID | Lot |
| 17 | 2123 |
I am looking to achieve this:
| ID | Location | ID Match | Weight | Lot |
| 11 | NY | 11 | 1 | null |
| 12 | DL | 12 | 2 | null |
| 13 | IN | null | null | null |
| 14 | TX | null | null | null |
| 17 | NY | 17 | null | 2123 |
I have created a relationship set up between the ID columns of the three tables. I want to add those rows from the second and third tables to the first table that have a matching UID.
I tried using the related function for the second table. But since I can only have one active relationship, I am not able to do the same for the third table.
Can anyone please give me any direction on how I can add rows from different tables to the first one that have a matching ID? Thanks!
Hi anshpalash
Please download the sample file attached.
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
3 Replies
Hi anshpalash ,
Whether the advice given by VahidDM has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
HenryHi anshpalash
Please download the sample file attached.
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Hi,
Use the Merge Queries feature of the Query Editor.
