Split Excel using Filter Criteria
This bot splits one input Excel into multiple Excel files based on a base loop Filter column and additional filter conditions.
Top Benefits
- Saves time in filtering and splitting the data in master file
- Fast and Efficient in creating multiple Excel files
- Can be used in any departments dealing with data manipulation using filters
Tasks
- Reads filter conditions from the config file
- Reads data from the input Excel
- Filters data using the filter conditions and saves output
- Send emails
This bot splits one input Excel into many Excel files based on a base loop Filter column and other extra filter conditions.
1. Bot will loop through a base loop column specified and generate reports. If base loop column is not specified, then bot will generate single report file based on the filter conditions provided.
2. Additional filter conditions can be provided along with base loop column. Filter conditions given under each serial number will generate a separate Excel spreadsheet.
3. Bot will send out emails with attached documents.
4. User can specify the unwanted columns in the output report and bot will remove those columns.
Common Use Case:
1. Master input Excel file can be split to many based on filter conditions.
2. Employees report like absence, compliance, etc can be split and sent to respective managers.
3. Vendor or Customer information can be segregated from the master file and emailed to respective associates.
4. Can be applied to any industry or departments.
$100 USD per bot
Annual Subscription
- Bot Security Program
-
Level 1
- Applications
-
- Business Process
- Finance & AccountingHuman Resources
- Category
- RPA Developer Tools
- Downloads
- 15
- Vendor
- Automation Type
- Bot
- Last Updated
- October 11, 2021
- First Published
- August 10, 2020
- Platform
- 11.3.3
- ReadMe
- ReadMe
- Support
-
- Ducont Systems
- Mon, Tue, Wed, Thu, Fri 9:00-17:00 UTC+0
- 00919962574544
- Manikandands@Ducont.com
- Bot Store FAQs
See the Bot in Action
Setup Process
Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Configure
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
Run
That's it - now the Bot is ready to get going!
Requirements and Inputs
- Update the necessary information in the Input Excel spreadsheet