Join datatable columns in for each rows

as the there is no column from left dt that we want to associate for the join condition with the right dt it is not a join. Its more about combine both datatables.

Would we merge the datatables with merge datatable activity then we would have it not combined.

A LINQ with a cartesian product is helping:

Reduced sample set input / result:


For setting up the combined structure of dtResult (combine lft and right datatable we exploit the the merge method on datatable.clone:

find starter help here:
CartesianProduct_CombineLRCols.xaml (9.4 KB)

1 Like