Merge Collections Transformation
Overview
The merge collections transformation create a new field with all the values in a set of selected multi-valued fields.
Use Cases
This transformation can be used to accomplish the following:
- Producing a set union of students in a certain collection of classes
- Joining two membership lists together
- Combining two lists where duplicate values are significant
Prerequisites
This transformation requires at least one multi-value field.
Contribution
This transformation adds a multi-valued target field containing the concatenated values.
Configuration
The merge collections transformation requires the following by way of configuration:
| Attribute | Description |
|---|---|
| Collections |
The list of collections that can be selected.
TIP: Ctrl+Click the selection to register it.
|
| Target Column | The new field to be added containing the concatenated multi-valued values. |
| Members Distinct | Whether the target field will only contain distinct values. |
Change Processing
During the change detection process, a change will be flagged if any of the source fields are updated in the base or relational connector.
Customer support service by UserEcho
