A powerful Data transformation language similar to Pascal is included in all our ETL and Business automation tools.

It can be used with Calculation Transformation FunctionPackage Script Action or inside any text object

mt_ignore::Transforming data using calculation function

mt_gallery:Embedded Data Transformation Language

Performance considerations

New users tend to rush using the scripting language.  Integrated transformation and validation functions offer much better performance and a lot of flexibility. The scripting language must be used as a last resort. If some function is missing please post your suggestion on our support forum. We would be happy to add it for you.

Next: The Basic Structure