Performing Calculations

Visual Importer ETL is capable of performing calculations during import.

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

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

[INTEGER_F] and [FLOAT_F] are source fields names

[INTEGER_F]+ kilos“

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

The good starting point is an Expression Editor.

  • vimpe/howto/performing_calculations.txt
  • Last modified: 14/07/2015 06:14
  • by admin