Hitachi Vantara Pentaho Community Wiki
Child pages
  • Set field value to a constant
Skip to end of metadata
Go to start of metadata

(warning) 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.


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.

  • No labels