Matching values from 2 datatable ( same structure ) without loop row

[NIVED_NAMBIAR (NIVED N)]

Hi @Mr.H

Apart from using join I think this query can help in

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Scope”)= If(dt2.AsEnumerable().Where(Function(r) r(“Name”).ToString.Equals(row(“Name”).ToString)).Count<>0,dt2.AsEnumerable().Where(Function(r) r(“Name”).ToString.Equals(row(“Name”).ToString))(0)(“Scope”).ToString, Nothing))

Use this code in invoke code with dt1 as in/out argument and dt2 as in argument here

I am assuming that dt1 is Input Table

dt2 is Output Table

Hope it helps

Mark it as solution if it solves ur query

Regards

Nived N

Happy Automation