Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-11-20 07:03 AM
Good afternoon, I'm new to the blue prism, there is an Excel file that I added to the collection in it 16 columns and 3000 rows, how to further work with the collection and how to get the necessary data from it? (First you need to get a string and then a few cells from that string)
------------------------------
Максим Уманец
------------------------------
------------------------------
Максим Уманец
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-11-20 02:35 PM
Use Loop with collection. Every iteration you'll get a next row and refer to its cells as [Collection.ColumnName].
------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------
------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-11-20 01:53 PM
It sounds like you haven't gone through Foundation Training, which teaches the basics of things like Collection Manipulation. You may want to reach out for training because even with Blue Prism, it's typically not a good idea to develop without having been trained on how to use it.
The short answer for now, though, is that you'll probably want to use Loop stages, choose the collection name inside the loop stage start, and then use calculation stages or multicalculation stages inside the loop with expressions such as [CollectionName.FieldName] to get the values.
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
The short answer for now, though, is that you'll probably want to use Loop stages, choose the collection name inside the loop stage start, and then use calculation stages or multicalculation stages inside the loop with expressions such as [CollectionName.FieldName] to get the values.
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-11-20 02:35 PM
Use Loop with collection. Every iteration you'll get a next row and refer to its cells as [Collection.ColumnName].
------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------
------------------------------
Andrey Kudinov
Project Manager
MobileTelesystems PJSC
Europe/Moscow
------------------------------
