I’m running multiple robots through Orchestrator.
My process builds an excel report of transactions processed which is sent to the client by email at the end of the process.
If I run the process on multiple robots, then multiple reports are produced and emailed to the client. One for each robot.
Ideally, for each job, I want a single merged report to be emailed to the client when the job finishes on the last robot to finish.
I could have the robots all writing to the same excel report file, but find that this can cause a conflict if multiple robots are trying to write at the same time. I also only want the last robot to finish to email the report to the client, or they would get three copies of the same report.
Any suggestions? Thanks.