This video showcases an AutomationEdge RPA Bot | Excel Bot | Salary Processing with formatted output based on a template. The output Salary file is formatted based on an input Excel template file.
=======================================
This workflow uses the following AutomationEdge Plugin steps: Microsoft Excel Input, Stream Lookup, Sort Rows, Group By, Merge join, Calculator, Microsoft Excel Output
Following is the complete list of videos on Data Massaging. Click on the links below to view the videos:
(1)Excel Bot for Data Massaging- https://www.youtube.com/watch?v=Lz5dkxL4IHs
(2)Excel Bot for Pay Slip Distribution with Mail Merge - https://www.youtube.com/watch?v=6rEij5tU7xc
(3)Excel Bot for Salary Transfer to Bank- https://www.youtube.com/watch?v=c7CjYhmypdE
(4)Excel Bot and send Mail- https://www.youtube.com/watch?v=P34RrDV7FF0
(5)Excel Bot to Read Timesheet Emails - https://www.youtube.com/watch?v=q5cKOlRB8lI
(6)AutomationEdge RPA Bot for Employee Data transformation - https://www.youtube.com/watch?v=7NLg0krRYSM
(7)Manage a Long-Running AutomationEdge RPA Bot | Excel Bot - https://www.youtube.com/watch?v=HZgY0i7s-ac
(8)Excel Bot to Combine Timesheets - https://www.youtube.com/watch?v=ewknhuSpbK4
(9)Salary Processing with formatted output based on a template - https://www.youtube.com/watch?v=D3zH6umOXXY
(10)Salary Processing and Reports based on an Excel template file-
========================
#StreamLookup #SortRows #GroupBy #MergeJoin #Calculator, #MicrosoftExcelInput #MicrosoftExcelWriter #MicrosoftExcelOutput #AutomationEdge rpa #hyperautomation bot workflow #roboticprocessautomation #dataprocessing #datatransformation