Advanced-etl-processor
Calculation
| Key | Value |
|---|---|
| Category | Transformation Function |
| Description | Allows 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
Useful Links
- Scripting Language
- Supported Functions List
- Best Practice for Calculations
- Working with python
- Download Python
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.
Back to Working with Transformer
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum
Last updated: September 17, 2022