PLEASE NOTE: This documentation applies to Pentaho 8.1 and earlier. For Pentaho 8.2 and later, see Set Field Value to a Constant on the Pentaho Enterprise Edition documentation site.
Description
This step allows you to replace the value of a field with a user-defined constant.
Option | Definition |
|---|---|
Step name | The name of this step as it appears in the transformation workspace. |
Use variable in constant | Selecting this option allows you to use variable replacement within a constant. |
Field | Displays the fields with values that can be replaced. |
Replace by value | The value that will replace existing values within the specified field. |
Conversion mask (Date) | Allows you to specify a date format to convert to. |
Set empty string? | Set this to Y to allow an empty string instead of a NULL value when the value is empty. |