Hi, Hope all are doing well. I wanted to know how to merge 3 data table which is having same “column” but the values are different. as of now i was working merging 2 data table with help of LINQ : “MergeDate= Year20.AsEnumerable.union(Year21.AsEnumerable,System.Data.DataRowComparer.Default).Cop…

HI @manipreethi410 try this Year20.AsEnumerable.union(Year21.AsEnumerable,System.Data.DataRowComparer.Default).CopyToDataTable.AsEnumerable.Union(Year22.AsEnumerable,System.Data.DataRowComparer.Default).CopyToDataTable Sample input Dt [image] Dt1 [image] Dt2 [image] Sample output [image…

How to Merge 3 dataTable?

Help Studio

Yamatendo (Constant Roux) October 27, 2022, 7:44am 2

Hello,

Have you just tried to do the same thing and just replacing Year as Year22 and Year21 as MergeDate.
You can store it into a final variable named FinalMerge for example ?

Topic		Replies	Views
Merge 3 datatables into one Studio studio , question , activities_panel	5	514	December 8, 2023
LINQ query to append 3 different data tables into 1 data table Studio datatable , excel , uiautomation , orchestrator , robot , activities , studio , data_scraping , string , studiox , question , activities_panel , linq , linq-query , linq-quey	4	3065	March 28, 2022
DataTable1 join DataTable2 Help robot , question	6	776	December 8, 2020
Merge on 3 DataTables to one DT Studio	3	384	March 30, 2023
How to merge/join DataTable with the same rows Studio	3	705	September 1, 2020

How to Merge 3 dataTable?

Related topics