From the course: Blue Prism: Excel Automation

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Prepare summary tab data

Prepare summary tab data - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Prepare summary tab data

“

- [Instructor] The last action we need to perform here is to save the GL number and the account balance in another collection which we'll later use to enter into the summary tab. Moving outside of the GL account data loop, first we create a new collection. The collection is going to be called, summary tab data. The collection will contain two fields. The first one will be GL account and it will be type, text. The second field will be called, amount and it will be type, number. Once updated, you can click on the okay button to save the window. Just after the end of the GL account data, we're going to create a new action. The action will be called, add row. For business object, select the collections and then add row action. The collection item we'll be adding a new row to is going to be the summary tab data so we can enter that into double quotation marks. Once you have updated the changes, you can close the window.…

Contents