Set field value to a constant
PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit 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. |