Datatable, Enumerable error

[prashant1603765 (Prashant Kumar)]

Hi @Parth_Sharma

Pls check this,

Join Datatable Using Linq

Hi Team, I have 2 DT as shown in below image, I want to join both as DT3 Using Linq, Anyone Kindly Suggest [image] [{D1E93AFD-7059-45B8-80E5-FD02152F87CB}] [{C5A4ADCC-6197-44EA-AF91-A882F6851F4F}]

OR

How to join two data table based on particular column

Hi @Raja.G How about this expression? (From data1 In Dt1.AsEnumerable() Join data2 In Dt2.AsEnumerable() On data1("XX no") Equals data2("XX no") Select DtClone.Rows.Add({ data2("XX no"),data1("Name"),data2("Status"),data2("Comment"),data2("Date")})).copytodatatable Check out the XAML file TwoDTJoinDataTable.xaml (12.4 KB) [image] Output [image] Hope it will helps Regards Gokul

Happy Automation