You can customize the extract by using only several fields from the main Data Object without using any other child Data Objects (mashups) as shown below in Taxonomy mapping.
There is instance performance benefit in removing unnecessary fields from the taxonomy definition.
The request will be automatically optimized to remove unused columns and even whole tables from the query.
Taxonomy mapping mode
In Taxonomy mapping mode the main Data Object you chose is at the left and the Taxonomy is at the right.
To map a field from the main Data Object to the Taxonomy, drag-and-drop it from the main Data Object to a Taxonomy field as shown below:
You can change the Name of output fields by clicking on the name you want to change and typing a new name:
It is possible to create calculated fields by using classic Message Center expression syntax.
Hera are some examples:
| Expression | Meaning |
|---|---|
| |ENTITY_ID| + '_' + |ENTITY_NAME| | Concatenating entity id with entity name |
| iif( stringlength(|POST_DATE|) = 0, |EFFECTIVE_DATE|, |POST_DATE| ) | Conditional assignment: if post date is empty, use effective date instead |
| convert( currenttime(), ''hh:mm:ss ) | Current time in custom format |
| convert( today() - 1, 'mm/dd/yyyy' ) | Yesterday's date in custom format |
Add Comment