The Transformation menu contains transformation settings, options, and properties.
Right-click any step in the transformation canvas to view the Transformation menu. Each menu item is described in the following table:
|Creates a new hop.
|Shows the configuration window for the step.
|Allows you to add a description to the step.
|Open Referenced Object
|Allows you to map a sub-transformation. Mapping a sub-transformation is covered in detail in Mapping.
|Allows you to inspect the data stream of a step once the transformation has
NoteThis option runs your transformation only if it was not previously executed.
|Run and Inspect Data
|Runs the transformation up to the selected step, then lets you inspect your data.
|Describes the way data moves through the transformation when there is more than
one hop. The following options are available:
|Change Number of Copies to Start
|Starts several instances of a step in parallel.
|Copies selected items to the clipboard.
|Makes a copy of the selected items, then pastes them to the canvas.
|Deletes selected items from the canvas.
Hides the step from the PDI client canvas.
If you hide the step, you will need to open the transformation or job XML file and hand edit it to view it again. For more details, see the troubleshooting section.
|Detaches the step or entry from the transformation or job.
|Shows metadata, like the field name and type, for fields that come into the step.
|Shows metadata, like the field name and type, for fields that go out of the step.
|Sniff Test During Execution
|The sniff test displays data as it travels from one step to another
in the stream. To use this, right-click a step in the transformation as it runs and
select Sniff Test During Execution. The following options are
For more information on how to use this tool, see the Sniff Test tool article.
|Check Selected Step(s)
|Checks transformation steps for problems that could interfere with successfully running the transformation. Right-click the transformation step that you want to check and click Check Selected Step(s). Warnings and errors appear in the Results of transformation checks window.
|Indicates how to apply error handling for a step. When this is selected, the Step error handling settings window appears.
|Allows you to preview the results of the transformation. Launches the Transformation Debug Dialog.
|Arranges steps on the canvas so that they are aligned properly or distributed
evenly. This helps create a visually pleasing transformation that is easier to read
Align refers to where the steps are permitted along the x (horizontal) or y (vertical) axis. Distribute makes the horizontal and vertical spacing between steps consistent. Typically, you turn on the grid, then move the different steps or entries on the canvas so that they form some sort of pattern, like a straight or branching line.
You select steps and apply the following options, as needed:
|Create, edit, delete, or test a Pentaho Data Service. The Pentaho Data Service allows others to obtain the results of a transformation, even if the person does not have the PDI client or Pentaho Server installed. The Pentaho Data Service is discussed in great detail in Pentaho Data Services.
|Provides a way for you to map target fields from the step to source columns in a
database. When selected, the Mapping window appears containing
the following fields:
When you click OK, the Mapping window closes and a Select / Rename Values step appears on the canvas. It is usually named after the step that right-clicked. The Select / Rename Values window contains the mappings. If you are not able to make mappings, the step still appears, but the properties are blank.
|Splits data into subsets according to a rule that is applied on a row of data. Partitions are discussed in detail in the Partitioning data article.
|Allows you to create Carte clusters. For more information, see Use Carte Clusters.