I have a unique xls where other people are adding rows throughout the day and I want that my “for each row” starts at the last row+1 that I previously processed. I don’t know the best way to do this … record the last processed row number somewhere and go read it whenever the process is run? thanks!
If you’re having a single bot process the data, you could store the last row number in a queue in Orchestrator. Or, you can save the last row processed in a text file to be read by the process.
@Pedro_Santos - pls try below
create asset in orchestrator (like - ast_last_process_Row_No)
read before your process activity… set the iteration number
once you complete the data actvity - set the asset with last row number of the excel.
2 activities 1) Get Asset Activity 2) Set Asset Activity