Get values by comparing the Name from 2 diffrent tables and write in the value in 2nd table

Listing a few options

  • Join DataTable Activity and processing the JoinResult
  • LINQ

also have a look here:

Maybe you can tell us if you are interessted on a inner or left join