Linq Compare 2 Data Table and Update Column Result

[Yoichi]

Hi,

Can you try the following sample?

 dt1 = dt1.AsEnumerable.Select(Function(r) dt1.Clone.LoadDataRow({r(0),if(dt2.AsEnumerable.Any(Function(r2) r("ID").ToString=r2("ID").ToString),"Success","Failed")},False)).CopyToDataTable()

Sample
Sample20240318-1a.zip (8.1 KB)

Regards,