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:
If it helped you, mark it as useful =]
------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55081988869544
------------------------------
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:
If it helped you, mark it as useful =]
------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55081988869544
------------------------------
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.
------------------------------
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:
Meu arquivo tem 3 colunas:
Column Name 1, Column Name 2, Column Name 3
Esse foi o resultado.
If I helped you mark it as useful
------------------------------
Emerson Ferreira
Sr Business Analyst
Avanade Brasil
+55081988869544
------------------------------
