Blue Prism - How filter a collection using NOT operator

Question

I need to filter a collection that have "HoldingSubholding" column, that can have lot of different value. I need All the rows with the values except the rows that have value "A".

How can I filter the collection? I would like to use EQUAL NOT, how could i write that?

"HoldingSubholding =NOT 'A'"

enter image description here

Please provide enough code so others can better understand or reproduce the problem. — Community, Mar 03 '22 at 17:44

score 0 · Answer 1 · answered Mar 29 '22 at 23:19

There's a VBO from the digital exchange, utility-collection manipulation. It has an action called filter collection- Input the collection and the filter expression "HoldingSubholding <> 'A'"

Or you can use a loop stage to loop through the collection, and a decision stage to check the condition [Collection.HoldingSubholding] <> "A"

score 0 · Answer 2 · edited Apr 24 '22 at 20:41

0

“[Column Name] <>’A’”

<> is exact opposite of = which allows you to deselect or filter out non relevant Data in columns.

edited Apr 24 '22 at 20:41

marc_s

732,580
175
1,330
1,459

answered Apr 24 '22 at 20:27

Mukesh Kumar

1
2

Blue Prism - How filter a collection using NOT operator

2 Answers2