Commonly used PDI steps and entries

Although there are over 330 transformation steps and job entries, some are used more often than others.

Use this page as a quick starting point. For full reference details, use the Pentaho Data Integration product documentation.

Jump to

• Top transformation steps

• Other commonly used transformation steps

• Common job entries

Top transformation steps

• Text File Input

• Table Input

• Microsoft Excel Input

• Text File Output

• Table Output

• Microsoft Excel Writer

• Select Values

• Filter Rows

• Group By

• Stream Lookup

Other commonly used transformation steps

• Input

  • Generate Rows

  • Data Grid

  • Get Data from XML

  • CSV File Input

  • Fixed File Input

• Output

  • XML Output

• Transform

  • Split Fields

  • Calculator

  • Add Constants

  • Add Sequence

  • Replace in String

  • Sort Rows

  • String Operations

  • String Cut

• Scripting

  • User Defined Java Class

  • Modified Java Script Value

  • User Defined Java Expression

• Flow

  • Abort

  • Append Streams

  • Block This Step Until Steps Finish

  • Blocking Step

  • Detect Empty Stream

  • Dummy

  • ETL Metadata Injection

  • Filter Rows

  • Identify Last Row in a Stream

  • Java Filter

  • Job Executor

  • Prioritize Streams

  • Single Threader

  • Switch/Case

  • Transformation Executor

• Lookup (for example, Stream Lookup)

• Joins

  • Join Rows

  • Merge Join

• Job

  • Get Variables

  • Set Variables

Common job entries

• General

  • Start

  • Job

  • Transformation

  • Success

• Utility

  • Abort

• Mail

  • Mail

• File management

  • Add Filenames to Result

  • Compare Folders

  • Convert File Between Windows and Unix

  • Copy Files

  • Create a Folder

  • Create File

  • Delete File

  • Delete Filenames from Result

  • Delete Files

  • Delete Folders

  • File Compare

  • HTTP

  • Move Files

  • Process Result Filenames

  • Unzip File

  • Wait for File

  • Write to File

  • Zip File

• Utilities

  • Write to Log