Merging two datatables into one

[Cormac (Cormac White)]

Hello,

I am trying to merge two data tables into one and wondering if anyone could help on the below.

In DT1 I have a data table with 1 line item but in DT2 I have multiple line items. I am attempting to merge the data from DT1 to each line item in DT2. Would anyone know the best way to do this?

DT1

DT2

Result New Microsoft Excel Worksheet.xlsx (10.8 KB)

[ppr (Peter | MVP)]

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…