Skip to main content
Pentaho Documentation

Get Started

Follow these instructions to begin creating your transformation.

  1. Click File > New > Transformation.
  2. Under the Design tab, expand the Input node, then select and drag a Generate Rows step onto the canvas.
    Note: If you don't know where to find a step, there is a search function in the left corner of Spoon. Type the name of the step in the search box. Possible matches appear under their associated nodes. Clear your search criteria when you are done searching.
  3. Expand the Flow node; click and drag a Dummy (do nothing) step onto the canvas.
  4. To connect the steps to each other, you must add a hop. Hops describe the flow of data between steps in your transformation. To create the hop, click the Generate Rows step, then press and hold the <SHIFT> key and draw a line to the Dummy (do nothing) step. File:/pdi_hop_step2step.png
    Note: Alternatively, you can draw hops by hovering over a step until the hover menu appears. Drag the hop painter icon from the source step to your target step.

    File:/pdi_hop_alternative.png

  5. Double click the Generate Rows step to open its edit properties dialog box.
  6. In the Limit field, type 100000. This limits the number of generated rows to 100,000.
  7. Under Name, type FirstCol in the Name field.
  8. Under Type, type String.
  9. Under Length, type 150.
  10. Under Value, type My First Step. Your entries should look like the image below. Click OK to exit the Generate Rows edit properties dialog box. File:/pdi_generate_rows_details.png
  11. Now, save your transformation. See Save Your Transformation.