Datatables Comparision

[vamsi.battulaus008 (vamsi)]

I wanted to compare one column in two datatables and find out the rows which are not matched from those columns in the two datatables and add them to a list.

[fernando_zuluaga]

hi @vamsi.battulaus008
check this please

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

Regards!

[Palaniyappan (Forum Leader)]

Hi
Kindly have a view in this

Unmatched records using LINQ

Need to fetch unmatched records from 2 data tables using LINQ query.

Once after getting the datatable with unmatched records
Use this expression in a assign activity like this to add this to a list variable

list_var = datatable.Asenumerable().Select(Function(a) a.Field(of string)(“yourcolumnname”).ToString).ToList()

Where list_var is a variable of type System.Collections.Generic.List(of string) with default value as New List(of string) defined in the variable panel

Cheers @vamsi.battulaus008