Set field value to a constant

(warning) PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit the Pentaho Enterprise Edition documentation site.


This step allows you to replace the value of a field with a user-defined constant.



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.


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.