Data values can be modified by applying no-code transformation actions.
- Multiple Mapping and replace actions can be combined
- Excel-style expression can be part of the cleansing/transformation sequence. Variables can be applied as part of the expression
- Data cleansing can use temporary database tables. SQL or non-SQL data manipulation actions can be applied. Variables can be used for parameterized actions or SQL.
- Structured For-Each looping can be applied for automating many transformation steps that are organized in a dependency hierarchy. Each value in the data set is referenced as a Variable. The data set can come from CSV, Excel, JSON, XML, REST, SQL SELCT.
| Search and replace Based on a value pair list you can search a string for values of any data type and replace it with another value. |
 |
| Map values 1:1 Based on a value pair list you can map one value to another. |
 |
| Expression The is a complete Excel style calculation engine that you can use to manipulate data values. SQL Select you can use SQL as part of your expression to calculates values |
 |
Last modified:
21 December 2021