Hello World
Simple transformation to illustrate key concepts
Last updated
Was this helpful?
Simple transformation to illustrate key concepts
Last updated
Was this helpful?
In this workshop we're going to create the classic “Hello World” Transformation. The process will help define your own workflow for building data pipelines.
Learn how to create a new Transformation.
Add Transformation 'Steps'.
A 'Hop'.
And finally a 'Note'.
In Spoon, click File > New > Transformation.
Any one of these actions opens a new Transformation tab for you to begin designing your transformation.
By clicking New, then Transformation
By using the CTRL-N hot key
Generate rows outputs a specified number of rows. By default, the rows are empty; however, they can also contain several static fields. This step is used primarily for testing purposes. It may be useful for generating a fixed number of rows, for example, if you require exactly 12 rows for 12 months.
Sometimes you may use Generate Rows to generate one row that is an initiating point for your transformation.
To add the Generate Rows step, expand the ‘Input’ category in the Design tab, and drag the step onto the canvas.
💡Alternatively, enter ‘Generate Rows’ into the search bar.
Double-click on the Generate Rows to open step properties.
Ensure the following details are configured:
Step name
gr_hello-world
Limit
10
Name
message
Type
string
Value
hello world
Before we close this dialog and continue creating the transformation, let’s make certain the Step generates the data we expect.
Click Preview button. The ‘Enter preview size’ dialog is displayed.
In the ‘Enter preview size’ dialog, click the [OK] button.
Verify 10 rows of data with the message you entered is displayed, and then click the [OK] button to close the ‘Examine preview data’ dialog.
Click OK button to close the ‘Generate Rows’ dialog.
➡️ Next: Configure the Dummy Step