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?
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
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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.