Between DataTables read, extract and input data

Hello guys, first time posting here and I hope someone can help me. I’m a begginer at UiPath so maybe I’m asking something really easy but I can’t find a way to do it.

I have two datatables, one of them is one I created which are clients that have missing info (I’ll call it dt_incomplet) and the other one is the full datatable (I’ll call it dt_Full) which I used to make the other datatable.

The thing is I need to extract the names of the dt_incomplet, compare them on the dt_Full, find a match and extract the id of that client and write it on dt_incomplet

I’ve been trying to do it for a couple of days but I can’t find a way around I’ve tried a couple thing but nothing seems to work so far I need help

Thank you guys, hope your having a wonderful time tho


For Each Row (Row_incomplet) in dt_incomplet
For Each Row (Row_Full) in dt_Full
If Row_incomplet(“Name”).ToString = Row_Full(“Name”).ToString
// Match found, update dt_incomplet with the ID from dt_Full
Row_incomplet(“ID”) = Row_Full(“ID”)
Break // Exit the loop once a match is found
End If