Ok i think I understand. In table2, if it is F11 you want it to match 11 from table1.
If that is the case, then you have to do it in 2 parts. First, you have to clean up the table2 data, then you have to do the join. To clean the data, add another column in table2 datatable called “ID” (or whatever you want to call it). For each row in table2, assign row.item(“ID”) = Regex.Match(row.item(“Text1”).ToString,"\d+").Value
Now you have should have a matching identifier between the two tables.
Next, use the Join Data Tables activity and use the join wizard. put in table1 and table2 and output to a new datatable (i’ll call OutputTable). It doesn’t matter which input goes where because you want to do an Inner join type. Then change the bottom portion so table1 “ID” = table2 “ID”
Now you have a joined table. However, for some reason the join activity includes the joined field in both tables, so you’ll want to delete the extra field before writing to excel. Use the Remove Data Column activity to delete the newly created “ID_1” field from OutputTable.
Finally, write it back into excel using the Write Range activity & you’re all done!