Session 11 Data Massaging Use Case Part 2 Implementation Workflow Design

#AutomationEdge #RPA #ProcessStudio Welcome to Session 11 of the AutomationEdge Foundation Training! Here is a breakdown of what the video covers: Project Setup: Creating folders for input and output files and initiating a new workflow (prefixed with "WF"). Data Ingestion: Using the Microsoft Excel Input step to read candidate details (name, email, education, status) from an XLSX file. Data Routing: Implementing a Switch Case step to route candidate data based on their status: "Selected," "Rejected," or "On Hold." Output Generation: Saving "Rejected" and "On Hold" data into separate CSV files using the Text File Output step. Processing "Selected" candidates through a Formula step to calculate a "Date of Joining" (DOJ) by adding 10 days to the interview date and identifying the corresponding day of the week. Data Transformation: Utilizing the Rename Field step to change metadata, specifically formatting the date to a cleaner "DD/MM/YYYY" format and renaming fields for the final output. Execution and Verification: Running the workflow and previewing the final Excel output via the Microsoft Excel Writer step. 🔗 Useful Links: AutomationEdge Academy: https://automationedge.com/automationedge-... Book a Demo: https://automationedge.com/it-robotic-proc... #AutomationEdge #RPA #ProcessStudio #WorkflowAutomation #DigitalTransformation #RPATraining #AutomationEdgeAcademy