Performing Calculations

Simple calculation

To perform a simple calculation set mapping type to calculation and type constant or formula into calculation edit box

Manual Mapping

Multiplying fields

StrToFloat([INTEGER_F]) * StrToFloat([FLOAT_F])


[INTEGER_F]+ kilos"

More complicated examples

Iif(StrToFloat([FLOAT_F])> StrToFloat([INTEGER_F]),1,2)

The good starting point is an Expression Editor.

Expression Editor

More information about scripting language

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: September 17, 2022