Add Calculated Columns

You can add calculated columns before or after you have loaded the data.

After adding an initial calculated column, you can also set up nested columns that calculate new values based on other calculated columns. This can only be done after loading the data.

Activity Steps

1. Click on the Data Component in the Project Tree.
2. Select the Data Loader tab at the bottom of the Main Canvas.
3. Enter the Column Name for the new calculated column in the empty cell at the bottom of the Column Definition Table.
4. Enter the Expression for the new calculated column.
5. Select the Configure the Options Tab.
6. Select the Expression language that matches your expression from JScript, VisualBasic and CSharp.
7. Fill in any other relevant fields in the Column Definition Table.
8. Select the Configure the Loader Tab.
9. Click Reload Data or Load Data, depending on whether you have already loaded the data.