Reading data from csv
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-10-23 11:00 AM
Hi,
I want to read data from CSV file and add it queue. But I have large number of data I need to split the data and add to queue (Without using excel actions)
How can this be done?
If anyone have idea, please help me on this
------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-10-23 11:34 AM
Hi Soumya,
You can use Get CSV Text as Collection action from File Management VBO which will load all the data into collection. From the collection you can split the data based on your requirement and add it to queue.
------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Salman Shaik
------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Salman Shaik
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-10-23 06:12 PM
Hello, there are a few ways to do this, including 2 that are usually most used:
1. Through the File Management VBO utility and action called Get CSV Text as Collection
2. Using OLEDB usage example: https://www.youtube.com/watch?v=rF2fw42LWl8
Regards
------------------------------
Leonardo Soares
RPA Developer Tech Leader
Bridge Consulting
América/Brazil
------------------------------
Leonardo Soares
RPA Developer
América/Brazil
