Transformations and Mapping Tricks
Edge cases, performance tweaks, and customization tips for mapping and transformations.
- Ignore transformation when source has no records
- Ignore transformation when source file does not exist
- Use CLOB Format to transform source messages
- Modify the source message in a raw Format before passing it to the transformation
- Use a field value as a filename
- Use templates to define fields
- Handle field names with special characters
- Handle columns with a blank name
- Calculate field value
- Split the datasets into multiple files based on the value of a column
- Use XSLT when reading and writing XML documents
- Test XSL transformation in the Etlworks Explorer
- Use an Excel worksheet name as a field value
- Use a temporary database as a staging area