dtUpg.AsEnumerable().Where(function(row) dtMaster.AsEnumerable().Select(function(r) r.Field(Of String)("Column0".ToString)).Any(function(x) x = row.Field(Of String)("Column1".ToString))).ToArray

[Palaniyappan (Forum Leader)]

@glory1

can Join datatable be used for the datatables with different columns? not much idea in join datatable; also its huge data around 50K records.

Kindly try once with JOIN DATATABLE activity
And for this

@glory1

not finding ‘To Array’ or ‘CopytoDatatable’ - Please help

For copytodatatable or Asenumerable method
Kindly mention this assembly reference in xaml by opening that in notepad file

AsEnumerable is not a member of 'System.Data.Datatable'

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated. Thank you.

Cheers @glory1