Transformations
Transform your uploaded and extracted data using powerful data transformation queries to clean, restructure, and process your data to fit your use cases.
You can use data transformations, for example, to transform data within a table, to filter data from a table, or to join different source tables, etc. Data transformation is applied during data loading and is the preferred way to map source tables to the activity and enhancement tables required in the data model.
Data transformation provides an SQL-like interface that you can use to create SQL statements to perform all relevant steps of the data transformation. You need the appropriate SQL programming skills to specify transformation statements. Here you find a list of supported SQL function.
The transformation example shows you how to create data transformations.
You can manage data transformations in the Transformations section of a data set.
