You can use the merge datatable activity. First remove the blank ‘value’ column from your datatable, then merge dt2 into dt1. Now dt1 will have the columns: ID, NAME, VALUE, DATE, ADRESS, TEL, MAIL. You can re-order the columns by using the datacolumn.setordinal property if you’d like e.g. assign dt1.column(“Value”).SetOrdinal = dt1.columns.count - 1
This will be the fastest and easiest way.
The other way I would recommend is to use the inbuilt excel Vlookup() function instead of calculting within uipath. To do this you would iterate through each row and assign the
row.item("Value") = "=Vlookup(A" + RowNum.ToString + ",nameofworkbook'sheetname'$A$2$C$5,3,0)
This is just putting in an auto-incrementing excel formula into each cell. the RowNum should be tied to the for each output RowIndex (but first put RowIndex + 2 so it starts at 2 rather than 0). Then when you write wrange back to excel, it includes the vlookup formula for each value instead of passing over the exact values