DataTables - update a row based on another datatable

@adrian_sullivan

can you try this in invoke code activity

For Each r As datarow In dt2.AsEnumerable
If dt1.AsEnumerable.Any(Function(a) (a("FileCode").ToString).trim.equals(r("FileCode").ToString.Trim)) Then
	r("Processed")="Y"
Else
	r("Processed")="N"
End If
Next

2 Likes