SmartConnect 2018

Calculated Column

A calculated column takes values, performs a calculation, then outputs the value for mapping to a destination field.


To define a Calculated Column:

1.Open Map >> Create, or select the Maps Quick Link and double click on the map to be edited.
2.If creating a new map enter the map id and description.
3.If creating a new map enter the data source and key field information.
4.If creating a new map select the required destination, then double click on the mapping type required.
5.Select Additional Columns from the toolbar at the top of the mapping window.
6.Select Columns >> Calculated from the toolbar at the top of the columns window, or double click on a calculated column to edit.



7.Enter a name for the calculated column. Names must be unique within a map.
8.Enter the required calculation in the script area. Standard scripting functionality is available within this window. Note: the return value for a calculated column is a string.
9.Select Load Template if the script may be loaded from a predefined template. Select the required template and then provide any variable values requested. Select OK to return the script details to the calculation window.
10.Select Clear to return the script to the default script.
11.Select Validate to ensure that there are no compilation errors in this script.
12.Select OK to save the script. The calculation column will now be available for mapping to destination fields.

Calculated Column Details