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 collection expression

Filter collection expression - Blue Prism Tutorial

From the course: Blue Prism: Excel Automation

Start my 1-month free trial

Filter collection expression

“

In order to edit the filter within the filter weekly report data, double-click on the action along with the filter expression where we're going to start with constructing the expression in order to get only the rows relevant to the account currently being processed. The idea behind this expression is to concatenate two variables which should result in the filter collection. We will start with double-quotation marks which is followed up by the account number column from the weekly report data collection which will be surrounded in square brackets. Keep in mind if there is no space within the column name, you do not need to enter the square brackets. The next step is to enter the equal sign where we'll compare the value to the account number within the data collection. And here the expression becomes a bit more complicated as we'll need to use both single and double-quotation marks. The expression we have already entered on the…

Contents