The Options Tab

The Options tab enables you to configure the elements that will be merged in your model.

  1. Select the model whose entities you want to merge in the Model drop-down box.
  2. Select or enter the type of entities you are merging in the Type drop-down.
  3. Select Merge multiple sources on a single record if you want to spread the source information across multiple fields in a single record. Select Merge a single source on multiple records if you want the source information to be in a single field across multiple records.
  4. If you are merging multiple sources on a single record:
    1. Select the field that contains the source entities in the ID field. 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.
    2. If the input data stores the entity type with the ID, such as with _stp_id, check the In ID field box.
    3. If the input data stores the entity type separately, such as with _stp_label, check the In separate field box and select the appropriate field in the Type drop-down. This is often, but not always, the _stp_type field.
    4. To select a specific entity type, check the Literal box and select the appropriate field in the Type drop-down.
    5. Repeat steps a and b to define at least one more source ID for the merge. You can add as many sources as you like. You can also delete any source by clicking the red "X" that is to the right of the source ID.
    Note: By default, the first source will be considered the master source, but you can designate any of the sources to be the master. Properties for the master source will not be overwritten by properties for the other source(s).
  5. If you are merging a single source on multiple records:
    1. Select the appropriate field in the Group by drop-down.
    2. Select the field that contains the source entities in the ID field.
    3. If the input data stores the entity type with the ID, such as with _stp_id, check the In ID field box.
    4. If the input data stores the entity type separately, such as with _stp_label, check the In separate field box and select the appropriate field in the Type drop-down. This is often, but not always, the _stp_type field.
    5. To select a specific entity type, check the Literal box and select the appropriate field in the Type drop-down.
    Note: The entity in the first record of each group is considered the master. Properties for the master source will not be overwritten by properties for the other record(s).
  6. Click OK.