# 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