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