Warning: Undefined array key 1 in /home/tools/www/www/wiki/lib/plugins/note/syntax.php on line 103

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.

  • vimp/howto/performing_calculations.txt
  • Last modified: 17/09/2018 10:32
  • by admin