From the course: Blue Prism: Excel Automation

Unlock the full course today

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

Loop stage

Loop stage - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Loop stage

- [Instructor] Before we proceed into extracting the information from the weekly reports, and adding this to the consolidated report, we'll need to create the logic for repeating the same process for each of the weekly reports. This will be performed by using the Loop stage. Select the loop stage and place it just after the Get Files From Directory. Make sure the End stage is moved down so we make space for the Loop stage itself. Firstly, rename the stage to Weekly Reports. You will notice a collection dropdown below from which we'll select the weekly reports. Once selected, click on OK. In between the start and the end of the Loop stage, we'll create a reference to a new page. Select the Page reference and place it just between the weekly report. Here we're going to select add a new page and create a reference to it. Then click on Next. The name of our new page is going to be called Get Weekly Data. Once you have…

Contents