To map or unmap a Source Term with a Target Term in a Dataflow Set, access the Term Mapping overview page for a Model Object:
From here, you can:
Map a Source Term with a Target term
To map a Source Term with a Target Term, several possibilities depending on the mapping option selected:
- Automatic Mapping: the Mapping is based on the Source Term name:
- Target Mapping: you can choose manually which Target Term you want to map to the Source Term
Auto-map a Source Term with an existing Target
To auto-map a Source Term with an existing Target Term, you can select the Auto Mapping mode:
They Should have the same name.
Hover over the column Mapped for a non-mapped Source Term, and the plus icon appears:
Click on the plus icon:
- The Source Term is mapped with the Target term with the same name. The mapped icon appears for both Source and Target terms:
- The Target Term Expression is automatically filled with the Source Term:
- A notification confirms the correct update:
- If you hover over the column Mapped of the Target Term, Source, and Target appear with the minus icon so you can identify them as mapped together easily:
Auto-map a Source Term with a new Term
To auto-map a Source Term with a new Target Term, select the Auto Mapping mode:
No Target Term with the same name as the Source Term should exist, like here for the rowguid Source Term:
Hover over the column Mapped for this non-mapped Source Term, and the plus icon appears:
Click on the plus icon:
- A new Target Term is automatically created with the same name as the Source Term:
- The Source Term is mapped with the new Target term. The mapped icon appears for both Source and Target terms:
- The Target Term Expression is automatically filled with the Source Term:
- A notification confirms the correct update:
- If you hover over the column Mapped in the Target Term, a minus icon appears on both Source and Target so that you can identify them as mapped together easily:
Map a Target Term manually
To manually map a Target Term to a Source Term, select the Target Mapping mode:
Hover over the column Mapped for a non-mapped Source Term, and the plus icon appears:
Click on the plus icon. The selected mode is activated for the Source Term:
Hover over the column Mapped for the desired Target Term, and the plus icon appears:
Click on the plus icon:
- The Source Term is now mapped with the Target term. The mapped icon appears for both Source and Target terms:
- The Target Term Expression is automatically filled with the Source Term:
- A notification confirms the correct update:
- If you hover over the column Mapped of the Target Term, Source, and Target appear with the minus icon so you can identify them as mapped together easily:
Map a Target Term with an Expression
To map a Target Term with an Expression, click on the Context menu of the Target Term and select the Edit menu:
The Edit Term Mapping side panel window is displayed.
If the Expression concerns several Terms:
- The Source Terms are mapped with the Target Term. The mapped icon appears for all Source and Target terms:
- The Target Term Expression is filled with the Expression we wrote:
- If you hover over the column Mapped of the Target Term, Sources, and Target appear with the minus icon so you can identify them as mapped together easily:
Unmap a Target Term
To unmap a Source Term with an existing Target Term, hover over the column Mapped for a mapped Target Term, and the minus icon appears:
Click on the minus icon:
- The Source Term is unmapped from the Target term:
- A notification confirms the correct update:
Auto map Source Terms with Target Terms
To auto map the Source Terms with the Target terms, click on the Context menu for a Dataflow Set and choose the Auto Map All menu:
A confirmation pop-up appears:
Click on the MAP button:
- All the Source Terms with the same name as a Target term are mapped to them. If a Source Term doesn't match a Target Term name, a new Target Term is created:
- A notification confirms the correct update:
Demonstration video