Linq help

[ldiaz (Leonardo Diaz)]

hi . how can i copy data from row using linq.
i’m comparing 2 id in two different excel . and if the the id in excel 1 find the id in excel 2 it will copy the value of specific column

i used this code to compare two id and write default value in specific column

If(IsNothing (MSMEDT.AsEnumerable.Where(Function (x) x(3).ToString.Equals(currentrow(7).ToString)).FirstOrDefault()),“”,“MSME”)

my goal now is to get the value of specific column with the same condition.

please help me

[kumar.varun2 (Varun Kumar)]

Hi @ldiaz

Can you share the sample input and required output.

[ldiaz (Leonardo Diaz)]

[kumar.varun2 (Varun Kumar)]

Hi @ldiaz

Try this approach

Refer the project

DT_CompareAndUpdateColumnValues.zip (15.3 KB)

[ldiaz (Leonardo Diaz)]

thank you sir. it works