Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at


Hitachi Vantara Lumada and Pentaho Documentation

Set Field Value to a Constant


The Set field value to a constant transformation step replaces the value of a field with a constant that you define.



Enter the following information in the transformation step fields.

Field Description
Step name Specify the unique name of this step on the canvas. You can customize the name or leave it as the default.
Use variable in constant Select to use a variable replacement within a constant.



Set field value to a constant

You can specify what fields to replace with the Fields table. Click Get Fields to populate the table with input from the PDI data stream. The table contains the following columns:

Column Description
Field Specify the field that contains the value you want to replace.
Replace by value Specify the value that will replace the original field value specified.
Conversion mask (Date) Specify a date format for the replaced field. See Common Formats for information on common valid date formats you can use in this step.
Set empty string? Specify Y to allow an empty string when the value is empty; otherwise, a null value is used.

Metadata Injection Support


All fields of this step support metadata injection. You can use this step with ETL metadata injection to pass metadata to your transformation at runtime.