Datatables Comparision

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.

hi @vamsi.battulaus008
check this please


Regards!

Hi
Kindly have a view in this

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