I am trying to accomplish this:
For each row in Excel File A(Has ~725 Rows), Read Column1 and compare it Excel File B (Has ~600 Rows) Column1. If they are equal, replace Excel File B Column1 with Excel File A Column2.
I am currently using nested for each row activities and an If statement. It works, but when I added a write line activity, you can see it takes about 45 seconds to get through each row in Excel File A. Extrapolating, that would be around 9 hours to run.
Is there something I can do to to speed up this process? Some other method that I am over looking?