Get started

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15

Begin inspecting your data by clicking on a step in the transformation.


Transformation with Data Inspection

The fly-out inspection bar appears at the top of the transformation canvas . The fly-out inspection bar displays the name of the step selected and contains two buttons for data inspection:

  • Run and Inspect Data button - Runs the transformation up to the selected step, then lets you inspect your data.

  • Inspect Data button - Lets you inspect the data of a step once the transformation has run.

Note: This option runs your transformation only if it was not previously executed.

After the transformation runs, a flat table of your step data is displayed with all the available fields selected in Stream View.


Data Explorer Sample Transformation

Additionally, you can begin inspecting data using these other methods:

  • Transformation menu: Right-click on a step and choose either Inspect Data or Run and Inspect Data.
  • Preview Data panel: Select the Preview Data tab. Click the Inspect Data button located at the top right of the Preview Data panel.
  • Actions menu: Select a step. From the Menu bar, click Action > Inspect Data or Action > Run and Inspect Data.
  • Keyboard Shortcuts: Select a step, and then using your keyboard, do the following:
    • In Windows and Ubuntu, press either Shift Ctrl F9 to inspect data, or Ctrl F9 to run and inspect data.
    • In OS X, press Shift Command F9 to inspect data, or Command F9 to run and inspect data.