Transformer

A Data Transformer modifies the format, structure, or values of data to meet specific requirements.

About input and output fields: *If a transformer is connected to any object other than the writer it is possible to modify the list of Outputs. When the transformer is connected to writer list of Outputs is taken from Writer. *List of Input fields is taken from the previous object

Transformer Toolbar

1. Properties: View or modify object properties.
2. Save: Save Changes.
3. Create New Tab: Open a new workspace tab.
4. Cut: Remove the selected item and place it on the clipboard.
5. Copy: Duplicate the selected item to the clipboard.
6. Paste: Insert content from the clipboard.
7. Delete: Remove the selected item.
8. Redo: Reapply the last undone action.
9. Undo: Reverse the last action.
10. Align Left: Align selected objects to the left.
11. Arrange Vertically: Organize objects vertically.
12. Align Right: Align selected objects to the right.
13. Align Bottom: Align selected objects to the bottom.
14. Arrange Horizontally: Organize objects horizontally.
15. Align Top: Align selected objects to the top.
16. Space Horizontally: Distribute objects evenly across horizontal space.
17. Space Vertically: Distribute objects evenly across vertical space.
18. Snap to Grid/Show Grid: Enable grid snapping or display the grid.
19. Print Mapping: Print the current mapping layout.
20. Print Preview Mapping: Preview the mapping before printing.
21. Automap Data: Automatically map inputs to outputs.
22. Delete All Objects: Remove all objects from the workspace.
23. Delete All Links: Remove all connections between objects.
24. Search Objects: Locate specific objects in the workspace.
25. Process Data: Execute the data processing.
26. First Record: Navigate to the first record.
27. Previous Record: Move to the preceding record.
28. Next Record: Advance to the next record.
29. Last Record: Navigate to the last record.
30. Show Source Data: Display the source data.
31. Zoom In: Magnify the view of the workspace.
32. Zoom Out: Reduce the view of the workspace.
33. Zoom Back to 100%: Reset the workspace view to the default zoom level.

Examples

Example below splits date field into Day, Month and Year using ‘/’ as a delimiter

Another Example Converts Store Name into More readable format:

Auto Mapping

Fill in all necessary data and click map

Transformation Functions

• Transforming Strings
• Transforming Numbers
• Date Transformations
• Time Transformations
• File Name Transformation functions
• Lookup Transformation Functions
• XML and HTML Transformation Functions
• JSON Transformation Functions
• Regular Expression Transformation Functions
• Miscellaneous Transformation Functions

Video Tutorial