Can someone please advise me on the flow of StudioX activity -
Step 1 - For my first activity, i Use Excel File activity and open the file
Step 2 - I use Filter activity to filter column based on a condition - eq empty
Step 3 - I use Excel for Each Row activity
Step 3a - Within the Use Excel for Each Row activity, i use if condition activity
Step 3b - If true, i perform Write cell & if false i skip current
My Excel sheet has around 80k rows.
My query - will the bot perform operation on entire 80k rows, or on the filtered records (retrieved in Step 2) which are around 35k rows.
When i ran this activity yesterday, the bot took ~ 5hrs 49mins to complete the task, and am thinking i did something wrong in my build path, as this is too long to perform a operation.
Appreciate your guidance.
Thank you in advance.