@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:
Flow:
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)