Changing a Field's Name

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.
  1. In a dataflow, double-click the channel between two stages. The Field Transform Options dialog box appears.
  2. 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.

  3. Click OK.