When I add a queue item which contains info about one of the departments, I increment the count by one for which ever department
How do I create code so that at the start of the day, it clears the counter values down so they are all zero, but if the process crashes during the day and restarts, the code recognises that it is the ‘same day’ and carries on to increment the count?
Create a project with a workflow with the following steps:
Read range from this excel file and store in a datatable(say DT1)
Now for each row in data table, if (row.item(“Department”) IsNot Nothing) write row.item(“Count”) = 0
After finishing for loop, write datatable to the same excel file using write range activity.
Publish this project to orchestrator and create a time based trigger(schedule) so that it runs once every day.
If you want to run it exactly at the start of everyday, then select “Daily” option in your trigger and give hours value as 0 and minutes value as 0 in the trigger