Split Excel using Filter Criteria

This bot splits one input excel to many excel files based on a base loop Filter column and extra filter conditions.

Top Benefits

  • Saves time in filtering and splitting the date for master file and send email
  • Fast and Effeciency
  • Can be used in any departments which does data manipulation using filter

Tasks

  • Read the Filter condition from the config file
  • Read the data from the input excel
  • Filter data using the filter condition and save output
  • Send email if necessary

This bot splits one input excel to many excel files based on a base loop Filter column and extra filter conditions.
1. Bot will Loop through a base loop column specified and generates reports. If base loop column is not specified, then bot will generate single report file based on the filter conditions provided.
2. Extra filter condition can be provided along with base loop column. Filter condition given under each serial number will generate separate excel.
3. Bot will send email with attached documents.
4. User can specify the unwanted columns for 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 and send across.
2. Employees report like absence, compliance, etc can be split and sent to respective managers.
3. Vendor’s or Customer’s information can be segregated from master file and emailed to them.
4. Can be applied to any industry or departments.

Buy Now

$100 USD per bot
Annual Subscription

Free 30-Day Trial

Request quote for more purchase options

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
August 10, 2020
First Published
August 10, 2020
Enterprise Version
11.3.3
ReadMe
ReadMe
Support

See the Bot in Action

Information to be provided in Config file
Filter Criteria for splitting data
Input folder where Base excel file should be available
Output folder where output will be saved
Sample output
Error log in 'txt' file
PREV NEXT
Information to be provided in Config file
Filter Criteria for splitting data
Input folder where Base excel file should be available
Output folder where output will be saved
Sample output
Error log in 'txt' file

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

  • Microsoft
  • Update necessary information in Column 'B' "Input Excel.xlsx