Hi Team, I want to join two data table based on XX no(column), that column is unique , please help me anyone for this. Input excel 1: [image] Input excel 2: [image] Expected output: [image] Regards, Raja G

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

How to join two data table based on particular column

Help Activities

Gokul001 (Gokul Balaji) October 28, 2022, 11:16am 12

HI @Raja.G

Check out the XAML file

TwoDTJoinDataTable.xaml (16.0 KB)

Regards
Gokul

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Merge rows in a data table Activities datatable , uiautomation , activities , question	7	613	July 10, 2023
How to join two datatable all columns based on join conditions using linq query Help datatable , activities	0	1348	June 27, 2019
Join activity Studio studio , question , activities_panel	9	363	May 12, 2023
Join Data Tables Help datatable , excel , activities , question	2	2723	December 11, 2019
How do i join two data tables based on 2 conditions Help studiox , question	2	1758	December 22, 2020

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

How to join two data table based on particular column

Related Topics