Running Calculations During Import

All versions of Visual Importer , Data Exchange Wizard and our ActiveX components is capable of performing calculations during import.

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

Assings constant to a field

 Perfoms simple calculation

Note:
      For character type fields type '12' or "12''

Multiplying fields
     [INTEGER_F]*[FLOAT_F]

Concatenation
     "[INTEGER_F]"+ " kilos"

 Note quotes aroud field name

More complicated examples
      Iif([FLOAT_F]>[INTEGER_F],1,2)
      Trim('[CHAR_F]')

You may also use an Expression Editor.

 

See full list of functions