Data Transformation Tables
![Close the expanding text drop-down element](../../../../../Skins/Default/Stylesheets/Images/transparent.gif)
- In the View section, select an appropriate list view from the drop-down list to go directly to that list page, or click Create New View to define your own custom list view. List views let you display a list of records that match specific criteria.
- In the Recent section, select an item from the drop-down list on the right to display a brief list of the top records matching that criteria. The choices are listed in the table that follows.
- From the list, you can click any Data Transformation Table Name to go directly to its detail.
- Click New to create a new data transformation table.
- To change the owner of one or more records, select the records you want to change from the list view then click Change Owner.
- To change the value of an editable field shown in the list double-click it, enter the value you want and click Save.
Recent Choice |
Description |
|
---|---|---|
Recently Viewed |
The last 10 or 25 records you viewed, with the most recently viewed item listed first. This list is derived from your recent items and includes records owned by you and other users. |
|
Recently Created |
The last 10 or 25 records you created, with the most recently created item listed first. This list only includes records owned by you. |
|
Recently Modified |
The last 10 or 25 records you updated, with the most recently updated item listed first. This list only includes records owned by you. |
Foundations data transformation tables enable you to transform data received in a message so that it is appropriate for the target field in the subscribing application. You can create data transformation tables that contain one or more data transformations. Each data transformation contains one or two source values and the target value.
When you create a mapping on a messaging relationship, you can optionally specify a data transformation table to apply. For example, you may receive messages via a subscription that contain information about people and their job roles. If a message contains information regarding an architect with one year's experience, you can create a data transformation table to convert this into a specific job role of Junior Architect.
Source Value 1 | Source Value 2 | Target Value |
---|---|---|
Architect | 1 year | Junior Architect |
In this second example, a senior business analyst is transformed to a business analyst. The optional source value 2 is not used.
Source Value 1 | Source Value 2 | Target Value |
---|---|---|
Senior Business Analyst | Business Analyst |
The following table provides examples of mappings that include two sources for data transformation.
Source Value 1 | Source Value 2 |
Matching Value for Source Value 2 on Data Transformation |
Data Transformed |
Actual Target Value |
---|---|---|---|---|
Developer | 1 year | Yes | Yes | Junior Software Developer |
Developer | Yes (null) | Yes | Software Developer | |
Senior Business Analyst | Yes (null) | Yes | Business Analyst | |
Senior Business Analyst | No | No | Senior Business Analyst |