Hi All, Datatable1 Column A Column B Karan 28 Rahul 29 Ashu 30 Datatable2 ColumnA ColumnB column C Ashu 20 Charan 30 Kimble 40 I have read both the datatable using read range now in dt1 and dt2. Now I need to check if ro…

@Karan28 the Join activity did a good job for doing the full Join [grafik] Linq was helpfully for bring it into the target structure: (From dj In dtJoin.AsEnumerable Let c1 = If(String.IsNullOrWhiteSpace(dj("Column1").toString), dj("Column1_1"),dj("Column1")) Order By c1 Let ra= New Object(){c1,…

Full Join - compare datatable 1 with datatable 2 - return matching and not matching items

Help Studio

Karan28 (Karan Arora) June 23, 2020, 12:50pm 12

Hi I have explained issue in the attached excel file .Please refer to this

How to join two datatables and get duplicate and non duplicate items in column 1 from both datatables

Topic		Replies	Views
Check Dt1 Column1 all Values Exist In the Dt2 column 1 Activities datatable , excel , question	11	324	October 14, 2023
Compare Datatables one specific column with other specific Column with "contains" or "like" Academy Feedback	5	1256	April 29, 2019
Comparing the same row from two datables Help	9	1160	June 13, 2018
Comparing values from two data tables Help	6	1005	August 9, 2019
Comparison of two data tables Help	12	1760	March 2, 2020

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Full Join - compare datatable 1 with datatable 2 - return matching and not matching items

Related Topics