as per title, I have a robot dispatcher that provides, every day, the loading of some items inside a queue.
Several performers, instead, always daily, take the items and process them.
My question is: how can I manage a single final report, in excel format, considering that according to the daily loads the number of performers can vary, and that I don’t know in advance when the last performer will finish the processing, so all the items in queue?
The doubt arises from the fact that, if two robots simultaneously access the same daily report excel file, this would cause a crash in the writing of the final report.
Create a queue for reporting. Create a single automation that reads from that queue and writes to the Excel file. Your multiple performers fill that queue with the items to be logged.
In fact this is how we do ALL logging. We have a generic logging automation, and drop items into its queue from multiple automations. The queue item contains all the info like the path and location to write to, the data to write, etc.