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?
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)