Working with Transformer

Data transformer is used to change the format, structure or values of data.


Transformer Properties

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

Transformer Toolbar
  1. Properties
  2. Create new tab
  3. Cut
  4. Copy
  5. Paste
  6. Delete
  7. Redo
  8. Undo
  9. Align Left
  10. Arrange Vertically
  11. Align Right
  12. Align Bottom
  13. Arrange Horizontally
  14. Align Top
  15. Space Horizontally
  16. Space Vertically
  17. Snap to grid/show grid
  18. Prints Mapping
  19. Print Preview Mapping
  20. Automap data
  21. Delete All objects
  22. Delete All Links
  23. Search Objects
  24. Process Data
  25. First Record
  26. Previous Record
  27. Next Record
  28. Last Record
  29. Show Objects Panel
  30. Copies Inputs to Outputs (Only visible if transformer is connected to any object other than writer)
  31. Zoom In
  32. Zoom Out
  33. Zoom back to 100%


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

Transformer Example 1

Transformer Example Result 1

Another Example Converts Store Name into More readable format:

Transformer Example 2

Transformer Example Result 2

Auto Mapping

Fill in all necessary data and click map

Auto Mapping

Transformation Functions

Video Tutorial

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: May 30, 2023