Extract from Array
Description
This activity extracts elements from an array stored in a column. It allows extracting a specific index or a range of index values based on user specifications.
Input
Data only
Output
Transformed data
Configuration Fields
- Column Name name of the column(s) to be processed.
- Include Original (switch) If enabled, keeps the input data columns along with the transformed columns. If disabled, only the transformed columns are given as output
- Output Column The name of the new column where the extracted elements will be stored.
- Index The specific index of the element to be extracted. (Rendered only when “Extract Sub-Array” is disabled.)
- Start Index The starting index for extracting a sub-array. (Rendered only when “Extract Sub-Array” is enabled.)
- End Index The ending index for extracting a sub-array. (Rendered only when “Extract Sub-Array” is enabled.)
- Extract Sub-Array (switch) | A Boolean that specifies whether to extract a sub-array or a single element.
Sample Input
| ID | DataArray |
|---|---|
| 1 | [10, 20, 30, 40, 50] |
| 2 | [5, 15, 25, 35, 45] |
| 3 | [100, 200, 300, 400] |
Sample Configuration
Sample Output (Extracting index 1 to 3)
| ExtractedValues |
|---|
| [20, 30, 40] |
| [15, 25, 35] |
| [200, 300, 400] |