Blue Prism - How filter a collection using NOT operator

[VittorioCimmino]

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'"

------------------------------
Vittorio Cimmino
------------------------------

[devneetmohanty07]

Hi Vittorio,

Try using the expression: "HoldingSubholding <>'A'" and let me know if that works?

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

[MichealCharron]

@VittorioCimmino

NOT is a logical negation operator ​so you have to make your comparison first before you apply NOT to the result of the comparison. In the case above, you can use:

"NOT HoldingSubholding='A'"

As @devneetmohanty07 pointed out, you can also use the "<>​" comparison operator to achieve this.

------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------

[MarcoSchulze1]

You can try:

"[HoldingSubholding] = NOT  Like '*A*'" (this is with a wilcard)
"[HoldingSubholding] = <> 'A'" (this is better)



------------------------------
Marco Schulze
RPA Development
EWE
Europe/Berlin
------------------------------