Using a Calculation

  1. Under the Integration tab click on the Additional Columns tab.
  2. Click on the Add Additional Column button.

  3. The Additional Column window opens.

  4. Name – enter a name for the column.
  5. Type – select Calculation.
  6. Additional fields are displayed in the window.

  7. Enter the required calculation in the script area. Standard scripting functionality is available within this window.
  8. The Source Columns and Global Variables sections can be expanded and contain columns and variables, respectively, that can be used in the calculation script.
  9. Select OK to save the script. The calculation column will now be available for mapping to destination fields.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.