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. |