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.

Filter weekly report data

Filter weekly report data - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Filter weekly report data

“

- As we now have a collection with a unique GL accounts from the weekly data reports we can proceed into calculating the balance for each of the GL accounts. In this part of the process we'll need multiple loops to go through the GL Accounts collection but we'll also need to filter once again the weekly data collection to get all of the rows associated with this GL account. The first step is going to be to create a new loop stage which will be just after the weekly data Loop stage. Double-click on it and call it "GL accounts". From the collection drop-down, select the GL accounts collection and click OK. You can move away the End stage just after the GL account's loop stage. And also by doing this we make sure we perform all of the steps for each of the GL accounts. This will be followed up by a new action which will be performed just after the start of the loop. Double-click on it and call it "Filter Weekly Data…

Contents