Data transformer is used to change the format, structure or values of data.
To change Transformer properties double click on it
If no data is present in the grid check the previous step execution log.
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
Create new tab
Snap to grid/show grid
Print Preview Mapping
Delete All objects
Delete All Links
Show Objects Panel
Copies Inputs to Outputs (Only visible if transformer is connected to any object other than writer)
Zoom back to 100%
Example below splits date field into Day, Month and Year using ‘/’ as a delimiter
Another Example Converts Store Name into More readable format: