There are a variety of situations where you may need to rename a field in a dataflow. For
example:
- A stage's input requires certain field names but the previous stage's output
uses other field names
- There is data in a field which you want to preserve when a downstream stage writes data to a
field of the same name
Note: After a field is renamed, it is no longer available in subsequent stages with the old
name.
-
In a dataflow, double-click the channel between two stages. The Field Transform
Options dialog box appears.
-
Change the field name(s) as desired.
For example, the latter stage could require "AddressLine3" but the former
stage uses "FirmName" instead. In this case, you would click the drop-down
arrow in the Input Field Name that corresponds to AddressLine3 as the Output
Field Name and then select "FirmName."
The color of the output field name changes to green.
-
Click OK.