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.
Simple calculation
To perform a simple calculation set mapping type to calculation and type constant or formula into calculation edit box
Multiplying fields
StrToFloat([INTEGER_F])* StrToFloat([FLOAT_F])
[INTEGER_F] and [FLOAT_F] are source fields names
Concatenation
[INTEGER_F]+ kilos“
More complicated examples
Iif(StrToFloat([FLOAT_F])> StrToFloat([INTEGER_F]),1,2) Trim('[CHAR_F]')
The good starting point is an Expression Editor.
More information about scripting language
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL Forum