dewizard:howto:perform_calculations

Performing Calculations

Data Exchange Wizard 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

Multiplying fields

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

Concatenation

[INTEGER_F]+  kilos"

More complicated examples

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

You may also use an Expression Editor.

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

  • dewizard/howto/perform_calculations.txt
  • Last modified: 17/09/2018 09:44
  • by admin