...
The Get Element from Collection activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Filter Index (text box editor type) (type: string): the index of the column from where you wish to extract the element (can be an integer or one of the name indexes specified in the 'Name indexes' parameter). If no value is specified, '0' is set by default.
- Input Collection (text box editor type) (type: collection<collection<string>>collection<string>, string, any collection type): the input collection. Bind this parameter with This parameter can be bound to a collection type Output parameter from an activityanother activity. In the example above the Output Collection from a Select From Database activity is used.
- Name Indexes (text box editor type) (type: string): the name of the column indexes of the current collection, separated by comma ','.
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Collection of Objects From String activity:
...
- In this example, only the Company value is desired to be output separately from the Collection.
The Read Only Output variable are the possible output values that the activity will provide:
- Collection Count (type: int32): outputs an integer equal to the collection count.
- CSV String (type: string): outputs a string containing the elements of the collection separated by ','.
- Element (type: string): outputs the string value of the element indicated by the 'Filter index' parameter.
- Element Object (type: object): outputs the element indicated by the 'Filter index' parameter.
Execution:
- the activity will extract the entire element from a collection, by default outputting the value into a CSV string:
- a next step is to extract different information if the Filter Index and Name Indexes fields have values (Filter Index field is the one with priority) and outputting the values into the Element variable (the variable's value was displayed using a Log Track Data activity). In our example, the value for the Company item should be displayed:
