Set field value to a constant
Description
The Set Field Value To A Constant transform replaces the value of a field with a hard coded constant value that you define.
Options
Option | Description |
---|---|
Transform name | Name of the transform this name has to be unique in a single pipeline. |
Use variable in constant | Select to use a variable replacement within a constant. |
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 transform. |
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 transform support metadata injection. You can use this transform with ETL Metadata Injection to pass metadata to your pipeline at runtime.