Hi,
Thank you for the task. I have tested the task and it works well however I have found that the way the task is written is not suited to my needs because in the current format, it would take a very long time to work its way through 30,000 rows of data.
One way I can think to improve the speed of the task is to write the values for columns E and F just after the value for column c is written in session1. That way the automation will not need to cycle through the rows twice. Do you think that will help?
Can you think of any other ways we can write this automation to speed up the process?
Thanks and regards,
Tony
|