Merge Multiple CSV Files into a Single CSV
This bot merges multiple CSV files into one standard consolidated CSV file
Top Benefits
- Avoids using loops
- Avoids connecting to Excel as database
- Merge CSV files at faster rate
Merge multiple CSV files having the same headers into a consolidated CSV file at a faster rate.
One can utilize this bot while trying to merge multiple CSV files into one consolidated CSV file, generally used while data is being extracted from multiple data sources with an end goal of producing a single source of truth by creating a single standard data file.
Key Use Case: Merge the general ledger present in CSV format into a standard consolidated GL file. Merge the general ledger present in CSV format into a standard consolidated GL file.
Automation 360 version of this bot: https://botstore.automationanywhere.com/bot/automation-360-merge-multiple-csv-files
Free
- Bot Security Program
-
Level 1
- Applications
-
- Business Process
- Information Technology
- Category
- Utility
- Downloads
- 669
- Vendor
- Automation Type
- Bot
- Last Updated
- May 6, 2021
- First Published
- April 11, 2019
- Platform
- 10.5
- Support
-
- Community Support Only
- Pathfinder Community Developer Forum
- 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
- AA std requirements
- Inputs: CSV file having same headers