The Rename component lets you change field names within the data flow.
By default, all input columns are mapped into output columns of the same name. Any field can be dropped from the list (this is a convenient way of dropping fields), or their names can be updated.
|Name||String||A human-readable name for the component.|
|Column Mapping||Source Column||All input fields are available, and can be added multiple times to create copies of a field.|
|Target Column||The output field name. Use this field to rename the column.|
|Include Input Columns||Dropdown||If Yes, uniquely named input columns will be included in the output. Any renames that duplicate an existing input column will take priority. The default setting is No.|
Generates an SQL-like SELECT query to rename columns in a table.
In this example, we have a table of flight data that we want to share with other people, but unfortunately the column names are not named as usefully as they could be. We can, however, change those column names using the Rename component as shown in the job below.
A Table Input component is used to load our table 'flights' and is linked to the Rename component. The Rename component itself has only 2 properties and we are only interested in the 'Column Mapping'.
In Column Mapping we click 'Add All' to see what our options are. From the list we note that crsdptime, crsarrtime and crselapsedtime can be better named departure_time, arrival_time and elapsed_time, respectively.
Taking a sample of the Rename component can show us what our final data will look like. Running this job will now rename the relevant fields.