Linq for Compare Two Columns in Different DT and Update in DT1

Help Activities
, ,
3

@Manii_K

Use invoke code activity and send dt1 as in/out and dt2 as in arguments

Dt1.AsEnumerable.
Where(function(x) string.IsNullOrEmpty(x(0).ToString)).
ForEach(sub(x) x(0) =dt2.AsEnumerable.
where(function(y) y(1).ToString.Equals(x(1).ToString).
Select(function(y) y(0).ToString).First)

Cheers