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.

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.