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.

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.

  • No labels