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
Use the Add Columns step in the data flow editor.
- Click Add a step (+), and select Add Columns.
- 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.