Delete relationships options

Choosing Relationships or Entities and relationships in the Delete box expands three categories of settings:

Source entity settings identify source entities of relationships to be deleted.
Relationships settings identify relationships to be deleted.
Target Entity settings identify target entities of relationships.

Relationships that match the criteria defined by all three categories are deleted from the model.

Source entity

These settings identify source entities for relationships in the model. Choosing one of the Location of entity type data options expands settings for the selected data location.


Location	Setting	Option	Description
Location of entity type data			The setting in this box specifies where the source entity type is located in the input data.
	In the entity ID field		Choose this setting if the source entity type and source entity label are in the same input data field. This field is known as the source entity ID field, such as `source._stp_id`.
		Entity ID field	Choose the input data field that contains both the source entity type and source entity label. This is often, but not always, the `source._stp_id` field.
	In a separate field		Choose this setting if the source entity type and source entity label are in different input data fields.
		Entity type field	Choose the input data field that contains only the source entity type. This is often, but not always, the `source._stp_type` field.
		Entity label field	Choose the input data field that contains only the source entity label. This is often, but not always, the `source._stp_label` field.
	Literal		Choose this setting to select a specific entity type.
		Entity type	Choose the appropriate entity type.
		Entity label field	Choose the input data field that contains only the source entity label. This is often, but not always, the `source._stp_label` field.

Relationships

These settings identify relationships between the source and target entities.


Setting	Description
Relationship label field	Choose the field that contains the relationship label to be deleted. This is typically, but not always, `Step1.stp_label`.
Unique ID is in a separate field	Check this check box if there are multiple relationships with the same label between the source and target entities, and choose the field that contains the unique ID. This is typically, but not always, `Step1.stp_key`.

Target Entity

These settings identify target entities for relationships in the model. Choosing one of the Location of entity type data options expands settings for the selected data location.


Location	Setting	Option	Description
Location of entity type data			The setting in this box specifies where the target entity type is located in the input data.
	In the entity ID field		Choose this setting if the target entity type and target entity label are in the same input data field. This field is known as the target entity ID field, such as `target._stp_id`.
		Entity ID field	Choose the input data field that contains both the target entity type and target entity label. This is often, but not always, the `target._stp_id` field.
	In a separate field		Choose this setting if the target entity type and target entity label are in different input data fields.
		Entity type field	Choose the input data field that contains only the target entity type. This is often, but not always, the `target._stp_type` field.
		Entity label field	Choose the input data field that contains only the target entity label. This is often, but not always, the `target._stp_label` field.
	Literal		Choose this setting to select a specific entity type.
		Entity type	Choose the appropriate entity type.
		Entity label field	Choose the input data field that contains only the target entity label. This is often, but not always, the `target._stp_label` field.