The Options Tab - 23.1

Model

In this box, select the model whose entities you want to merge.

Target

Type

In this box, select or enter the type of entities you are merging.

Merge multiple sources on a single record

Choose this option to spread the source information across multiple fields in a single record.

Merge a single source on multiple records

Choose this option if you want the source information in a single field across multiple records, and select the appropriate field in the Group by box.

Source

If you chose Merge multiple sources on a single record, you can add as many sources as you like, but you must configure the following options for at least two source IDs for the merge. When there are more than two sources, you can delete any source by clicking the red X that is to the right of the source ID. By default, the first source will be considered the primary source, but you can select the Master check box to designate any of other source as the primary source. Properties for the primary source will not be overwritten by properties for the other sources.

If you chose Merge a single source on multiple records, the entity in the first record of each group is considered the primary. Properties for the primary source will not be overwritten by properties of other records.

ID

Select the field that contains the source entities in this box.

• To merge multiple sources on a single record, this is often, but not always, the _stp_id field if the ID and type are together, or the _stp_label field if the ID and type are separate.

Type as

• In ID field—Choose this option if the input data stores the entity type with the ID, such as with _stp_id.
• In separate field—Choose this option if the input data stores the entity type separately, such as with _stp_label, and select the appropriate field in the Type drop-down list box. This is often, but not always, the _stp_type field.
• Literal—Choose this option to select a specific entity type, and select the appropriate field in the Type drop-down list box.