Merging two datatables into one

[ppr (Peter Preuss)]

have a look on the join datatable activity (inner join) and removel later the unneeded join columns with a filter datatable (column removal setting).

also have a look here:

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

as dt2 currently has not a common join datacolumn we can manipulate by e.g. adding an addtional datacolumn along with a default value set to the invoice number.

have alook here as well

DataRow as argument: How can I define default values?

@OKlink Build datatable / edit column [grafik] Add datacolumn: [grafik] by Api: [grafik] For using the default value, just assign nothing instead of value

so the flow could look like this

• add join col to dt2
• join datatable dt1 to dt2 inner join
• remove dt2 join datacolumn from join result

Another technique is to do the merge via row Itemarray construction and you can refer here:

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 m…