I have a robotic task that gets triggered from the smart service node in Process model. I am providing some details with respect to the bot so that I can get help exactly where we can improve the performance.Robotic task -> The robotic task receives an excel document, downloads it (download doc step), then it has to open the doc, and perform some excel actions(Sort,Find value,Filter etc) that we have configured using excel actions. The catch is that the bot first needs to check which action is it that it needs to perform (so we use if expression true to confirm the action, since this comes from the process model + DB).Now we have robotic sub tasks as well since there are close to 40 actions, therefore we have divided them.Configuration --> Download > Open workbook > Select sheet > Loop in actions > Pick first action > Run if expressions (present in sub bots) to confirm which action it is > Apply action > Will check other action until comes out of loop after executing all actions.Our problem -> On average it is taking over 3 min to execute any excel action (this is minimum or average), if there are more actions then it will take much more time.Expectation -> Need to reduce the time for 1 action to execute within a minute.The bot usually takes 30s-1 min in reaching the open workbook step itself, so obviously excel action will take time to complete.2 things we miss here is a switch case (something like a!match) that could directly help us land on that specific action step instead it keeps checking each step until it arrives on correct one that we want to execute.Second there is no break type of action that can help us get out of loop immediately once action is done.What in general can be done to improve bot performance, any experience with RPA performance related things that people have and can share, that will be helpful?
Discussion posts and replies are publicly visible
Hello, My Milestone Card
To improve the performance of your RPA robotic tasks, consider the following strategies:
Process Improvement: Analyze the process flow to identify and eliminate bottlenecks. Automation Optimization: Tune the automation logic and algorithms for efficiency. Code Enhancements: Refactor code for better performance and maintainability. Resource Management: Ensure efficient allocation and utilization of resources. Additionally, implementing a decision-making structure like a switch case and a break function to exit loops can significantly reduce execution time.
Hi, thanks for your response. Though I will check the improvement options mentioned, my interest is in knowing the switch case and break part you have mentioned here, since that is not directly available in RPA to use (at least to my knowledge). Therefore, can you help me with any example on how we can implement this or if you have links or docs to check this one?Thanks in advance.
Is this copied from ChatPGT? Would you mind making that clear?
Your response is too generic to really help.
Hi Stefan, yeah that response is generic in nature.Do you know if there is a possibility to replicate a switch case and break out of loop thing in Appian RPA since these are not available directly?
ayushsrivastava said:break out of loop thing in Appian RPA
I don't know it's gonna give you output you want and it's a ton of work and impacts performance . Instead of looping in RPA we can do that in process model. and based on your condition you can exist the loop. Or using "While Loop type" in appian RPA
Actually our use case binds us to use looping in RPA, since multiple excel actions need to be executed one after the other. Also we are not using While since we need to iterate on passed items.