Intersection intersection

An Intersection-type activity creates a target from the intersection of the targets received.

An intersection lets you extract only the population that is common to all inbound activity results. The target is created with all results received: all prior activities must therefore be finished before the intersection can be executed. To configure this activity, you need to enter a label for it as well as the options concerning the result.

For more on configuring and using the intersection activity, refer to Extracting joint data (Intersection).

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, as follows:

Intersection example intersection-example

In the following example, the aim of the intersection is to calculate the recipients common to three simple queries in order to create a list.

  1. After three simple queries, insert an Intersection -type activity.

    In this example; the queries respectively target men, recipients living in Paris and recipients aged between 18 and 30 years old.

  2. Configure the intersection. To do this, select the Keys only reconciliation method since the populations resulting from the queries contain consistent data.

  3. If you have inputted additional data for the queries, you may choose to keep only those that are shared by recipients by checking the relevant box.

  4. If you wish to use the rest of the data (in regard to the queries but not their intersection), check the Generate complement box.

  5. Add a list update activity after the intersection result. You can also add a list update to the complement should you wish to use this too.

  6. Execute the workflow. Here, two recipients apply to all three inputted queries at the same time. The complement is made up of five recipients who only apply to one or two of the three queries.

    The intersection result is sent to the first list update. If you have chosen to use the complement, it is also sent to the second list update.

Input parameters input-parameters

  • tableName
  • schema

Each inbound event must specify a target defined by these parameters.

Output parameters output-parameters

  • tableName
  • schema
  • recCount

This set of three values identifies the target resulting from the intersection. tableName is the name of the table that records the target identifiers, schema is the schema of the population (usually nms:recipient) and recCount is the number of elements in the table.