Regardless if the data is being imported or exported, or is being used within STEP, generally the transformation options have the same effect.
Transformations are available using the STEP Workbench import and export processes for formats that require Data Mapping as discussed in the Data Exchange documentation, and also using Attribute Transformations for attributes in the System Setup documentation.
For additional help importing data, refer to the Creating a Data Import topic. And, for additional help exporting data, refer to the Creating a Data Export topic.
Transformation options and availability are defined in the Transformations topic in the Resource Materials online help documentation.
For examples of some of the most commonly used transformations, refer to the sections below:
- Concatenate Column with Unit Data Example
- Concatenate Data Using Variables Example
- Concatenate into Single-Valued Data Example
- Dimension Point for Single Dimension Data Example
- Extract Characters at Position Example
- Extract Characters Between and Extract Characters After Example
- Format Number Example
- Header and Value Aspects Example
- If Equals Source Example
- Insert Text Example
- Math Operation Example
- Merge Attributes and Constant Example
- Merge Data for Multi-Valued Data Example
- Replace Substrings of the Value Example
- Replace the Whole Value Example
- Split and Extract Data Example
- Transform Date by Locale or by Pattern
- Transform Using Attribute Transformation Example
- Transformation Lookup Table Example
Additional examples using the Transformation Aspects parameter, refer to the Aspect - Transform Outbound topic.