Combine
The Combine activity allows you to perform segmentation on your inbound population. You can thus combine several populations, exclude part of it or only keep data common to several targets.
The Combine activity can be placed after any other activity, but not at the beginning of the composition. Any activity can be placed after the Combine.
Configure the Combine activity
Follow these common steps to start configuring the Combine activity:
-
Add multiple activities to form at least two different execution branches.
-
Add a Combine activity to any of the previous branches.
-
Select the segmentation type: Union, Intersection or Exclusion, and click Continue.
-
In the Sets to join section, check all the previous activities you want to join.
Union
In the Combine activity, you can configure a Union.
For this, you need to select the Reconciliation type to define how duplicates are handled:
- Keys only: this is the default mode. The activity only keeps one element when elements from the different inbound transitions have the same key. This option can only be used if the inbound populations are homogeneous.
- A selection of columns: select this option to define the list of columns on which the data reconciliation is applied. You must first select the primary set (that which contains the source data), then the columns to use for the join.
Intersection
In the Combine activity, you can configure an Intersection.
For this, follow the extra steps below:
- Select the Reconciliation type to define how duplicates are handled. See the Union section.
- You can check the Generate complement option if you wish to process the remaining population. The complement will contain the union of the results of all inbound activities minus the intersection. An additional outbound transition will then be added to the activity.
Exclusion
In the Combine activity, you can configure an Exclusion.
For this, you need to follow the extra steps below:
-
In the Sets to join section, select the Primary set from the inbound transitions. This is the set from which elements are excluded. The other sets match elements before being excluded from the primary set.
-
When necessary, you can manipulate inbound tables. Indeed, to exclude a target from another schema, this target has to be returned to the same schema as the main target. To do this, click Add a rule in the Exclusion rules section and specify the schema change conditions. Data reconciliation is carried out either via an attribute or a join.
-
You can check the Generate completement option if you wish to process the remaining population. See the Intersection section.
