Add Columns in a Data Flow

You can add columns to your target data and customize the format. For example, you might calculate the value of your stock by multiplying the number of units in a UNITS column by the sale price in a RETAIL_PRICE column.

Use the Add Columns step in the data flow editor.

1. Click Add a step (+), and select Add Columns.
2. In the Add Columns pane, use the expression builder to define your column. For example, to calculate the value of stock items you might specify UNITS * RETAIL_PRICE.
   Select SQL operators, functions, and conditional expressions from the expression pick list.