Calculation

KeyValue
CategoryTransformation Function
DescriptionAllows the end user to write scripts to transform data. The programming language used is very close to Pascal. It is also possible to use Python as scripting language
All data is coming in into the calculation as strings
The data is coming out of the calculation as a string.
All nulls are replaced with empty strings.

To change Transformation function properties double click on it

Calculation transformation is the slowest way to transform the data and it should be avoided.
If you do not know how to transform the data ask the question on our support forum and we will help you.

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

  • aetle/transformation_functions/miscellaneous/calculation.txt
  • Last modified: 17/09/2018 09:45
  • by admin