Combine/ join similar datatable column values

Help
1

Say I have Table1 with columns X, Y, Z and Table2 with columns X, Y, Z

I want to merge the two tables, but when column X in Table1 and Table2 match to merge their other column values (Y & Z) together separated by a comma (if different).

What is the best way to go about this?
Is there a fancy merge or join I can do, or must I iterate over each and merge them row by row?

Ex:
Table1
x----y----z
1—Happy—Gilmore
2—James—Bond
3—Neo—Anderson

Table2
x----y----z
1—Shooter—Mcgavin
3—Thomas—Anderson

output:
x----y----z
1—Happy, Shooter—Gilmore, Mcgavin
2—James—Bond
3—Thomas, Neo—Anderson

2

Just to confirm, you want a full outer join on the numbers (column x), then when column x matches between table1 and table2, you want to combine the values from the 2 tables separated by a comma.

Please correct me if these assumptions are incorrect. Assuming they are correct, this has to be done with a semi-complicated LINQ statement, or with multiple activities (such as merge datatable and a less complicated LINQ statement)

3

@Dave Yes, your understanding sounds accurate. I am not familiar with LINQ statement’s, I will take a look into that, thanks for the feedback!