For data transformation, MapForce provides an extensible library of data processing and conversion functions to filter and manipulate data according to the needs of your data integration or ETL project.
To save time and leverage work you’ve already completed and tested, you can even import existing data transformation code, user defined functions, or an XSLT 1.0, 2.0, or 3.0 file for use as a function library.
MapForce also includes a unique visual function builder to define and reuse custom functions that combine multiple operations. The visual function builder lets you create user-defined functions using a graphical interface. This makes complex data processing accessible to users who may not have programming expertise.
These functions can be used to perform complex data transformations or calculations that go beyond the built-in functions provided by MapForce. This feature is particularly useful when you need to apply specific business logic to your data mappings.
The visual function builder provides a drag-and-drop interface for building functions. You can connect various function components, such as constants, variables, operations, and built-in functions, to define the logic of the custom function.
Custom functions can be reused across different mappings within the same project, meaning you can define a function once and apply it wherever needed.
User-defined ETL functions can accept parameters, allowing for flexible and dynamic data processing. The visual function builder also supports conditional logic within custom functions. This includes if-else statements, case statements, and other conditional operations to handle complex data transformation scenarios.