cancel
Showing results for 
Search instead for 
Did you mean: 

How to Filter a Collection Column?

JOHNREYGABARRA
Level 3

Hello, Everyone.

I just collected a series of data with rows and columns from an Excel File.

But how do I filter it out?

So I only have a collection with a specific column.

Thank you!



------------------------------
JOHNREY GABARRA
------------------------------
4 REPLIES 4

EmersonF
MVP
Hello, you may be using the Filter action of the Collection Manipulation Object

It would look basically like this
"[Field Name] = 'Value Here'" if using parameters you can use "[Field Name] = '" & [Data Item & "'"

This is for operators
"[Field Name] = 'Value Here'"
"[Field Name] <> 'Value Here'"
"[Field Name] Like '% Value Here'"
"[Field Name] not like '% Value Here'"
Exemple:
633.png
If it helped you, mark it as useful =]

------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55081988869544
------------------------------
Sr Cons at Avanade Brazil

Hello, Thank you for answering.
I'm still trying to learn Blue Prism.

From my understanding Filter finds anything that answers the Syntax and Filters it.

Although I'm trying to find out how to take all the the Data in a Column.
Where the first Row is a Header.

634.png


------------------------------
JOHNREY GABARRA
------------------------------

Do you want to get a single excel column? If so, you can use the MS Excel VBO action:

1st Get Worksheet as collection (Offset): to capture a certain range of information then in your case it would look like this:


636.png
Meu arquivo tem 3 colunas:

Column Name 1, Column Name 2, Column Name 3

Esse foi o resultado.

637.png

If I helped you mark it as useful



------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55081988869544
------------------------------
Sr Cons at Avanade Brazil

EVIPUTI
MVP
Its worth giving a read for your use case . 
https://blueprism.training/blog/basics/filter-collection/

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------
------------------------------ Vipul Tiwari Senior Process Simplification Developer Amazon ------------------------------