There are two datatables. I want individual rows of dt1 to map on all the rows of dt2 with their column names. For more clarification, I have attached image, and want to achieve something like output datatable based on two dt1 and dt2.
Can anyone please help me to achieve this?
Thank you.
U can use join datatable activitiy
With below information
Join type : inner
First datatable : dt1
Second datatable: dt2
Resultant : dt3
Condition : clm3!=clm4
Mark it as solution if it helps you
Regards
Nived N 
Happy Automation 
@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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
