Time for action – getting data about shipped orders

Let's continue working with the sample data.

  1. Create a new transformation.
  2. Select the Design view.
  3. Expand the input category of steps and drag a Table Input step to the canvas.
  4. Double-click the step.
  5. Click on the Get SQL select statement... button. The database explorer window appears.
  6. Expand the tables list and select ORDERS.
  7. Click on OK.
  8. PDI asks if you want to include the field names in the SQL. Answer Yes.
  9. The SQL box gets filled with a SELECT SQL statement.
    SELECT
      ORDERNUMBER
    , ORDERDATE
    , REQUIREDDATE
    , SHIPPEDDATE
    , STATUS
    , COMMENTS
    , CUSTOMERNUMBER
    FROM ORDERS
  10. At the end of the SQL statement, add the following clause:
    WHERE STATUS = 'Shipped'
  11. Click Preview and then OK. The following window appears: ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.