Session 15 - Data Massaging use case Part 2

In this second installment of our data massaging use case, we continue building the workflow we started in Part 1. In this session, we dive deeper into advanced data manipulation techniques. You'll learn how to aggregate time-sheet data, lookup allowance rates based on roles, and format your final output into a clean XML file. What you’ll learn in this video: Data Aggregation: Using the Memory Group By step to calculate total hours worked from employee time sheets. Stream Lookup: Efficiently fetching specific data points from one stream into another. Data Merging & Sorting: Mastering the Merge Join step and understanding why sorting your data with the Sort Rows plugin is a critical prerequisite. Calculations: Using the Calculator step to determine total allowance amounts. Data Cleanup: Utilizing the Select Values (Rename field) step to remove unnecessary metadata before the final export. XML Output: Configuring the XML Output step to generate structured reports ready for the AutomationEdge server. 🔗 Useful Links: AutomationEdge Academy: https://automationedge.com/automationedge-academy/ Book a Demo: https://automationedge.com/it-robotic-process-automation-demo/ #AutomationEdge #RPA #ProcessStudio #WorkflowAutomation #DigitalTransformation #RPATraining #automationedgeacademy Keep watching and keep automating! #AutomationEdge #DataMassaging #RPA #WorkflowAutomation #DataIntegration #TechTutorial