To change the properties of multiple columns, right-click the columns in the middle pane and select Change Column(s).

Select the relevant check boxes in the left pane to specify the properties to be changed. Selecting a check box enables you to change the value for that field in the column properties.

In the Original Value column, select the value(s) to be changed.

  • Choosing (All) changes the selected property for all of the columns in the table.
  • Choosing (Selected) changes the selected property for the selected column in the table.
  • Choosing (Empty) changes the selected property for all of the columns where that property field is empty. This option is only available if there is a column where this property is empty.
  • Choosing one of the other options changes the selected property for all the columns in the table having that value.

    (Selected) is the default for the Original Value column.

    In the New Value column, select the new value to be assigned; or key in the new value.


    When editing the Column Source Table property, selecting the Update matched columns only check-box validates that the selected column name exists in the new source table. If it does not exist, then the update does not take place.


  • Selecting the Transformation check box enables you to define a transformation for the selected column(s). Refer to Column Transformations for details.|
     
  • No labels