Join datatable columns in for each rows

@shandilya.suthar15
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:
grafik

Flow:
grafik

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