In the last exercise, you used two variables: one created in the kettle.properties file, and the other created inside of Spoon at runtime. There are still more ways to define variables. One of them is to create a named parameter. Named parameters are variables that you define in a transformation, and they can have a default value. You only have to supply a value if it differs from the default. Let's look at how it works, as follows:
- Open the last transformation (if you had closed it).
- Double-click anywhere in the work area excepting over the steps or hops. This will open the Transformation properties window.
- Click on the Variables tab. This is where we define the named parameters.
- Fill in the grid as shown, replacing ...