How to Merge the two datatable in uiPath
To merge two data tables in UiPath, you can use the Merge Data Table activity. This activity allows you to merge two data tables by specifying the data table to merge and the data table to merge into, as well as the columns to use for the merge.
n this example, we will merge two different data tables made by reading Excel. In this example, we have two sheets having employee details in “Sheet1” & “Sheet2“
Sheet2
Step – 1: Open UiPath Studio
Open UiPath Studio and create a new project or open an existing one
Step – 2
Drag and drop a “Merge DataTable” activity onto the workflow
Step – 3
In the Merge DataTable activity, specify the two DataTable variables you want to merge.
- DataTable1: Input the first DataTable variable.
- DataTable2: Input the second DataTable variable.
Here, I have stored the sheet values in two separate Variable of type data Table as Dt_Table_1 & Dt_Table_2 by using read range activity
Step – 4
Configure the Merge DataTable activity by setting the following properties:
- Destination: Create a new DataTable variable to store the merged data. This will be the resulting DataTable after the merge operation.
- JoinType: Specify the type of join you want to perform. You can choose from Inner, Left, Right, and Full.
- JoinColumns: Specify the column(s) used for the join operation. You can select one or more columns from the available columns in both DataTables.
- PreserveSchema: Set this property to True if you want to preserve the schema (column structure) of the resulting DataTable. Set it to False if you want the resulting DataTable to have the merged columns from both DataTables.
Step – 5
Once you have configured the Merge DataTable activity, the resulting DataTable will contain the merged data based on the specified join condition.
Now I used the write range activity to write the merged data table value into the merge sheet of example.
Here, Dt_Table_2 contains the value of Dt_Talbe_1 too.
The output is
You can perform further operations on the merged DataTable, such as writing it to a new Excel file using the “Write Range” activity or processing the data in subsequent activities. Remember to ensure that the two DataTables have compatible column structures for the merge operation.