This section provides detailed procedures on the different types of data transformations you could perform.
You can transform your data using the in-built transformation steps, or through certain functions in the data preview panel or the configure panel. Transformation widgets for data science models are also available in Yellowfin's Marketplace, that allows users to integrate data models, such as PMML, PFA, R and H2O, into their platforms and apply them on their data.
Transformation | Related Component | Description |
|---|---|---|
Aggregate | In-built transformation step | This step transforms your data into a summary form, by applying functions like count, count distinct, sum, average, etc. |
Calculated Field | This step creates a calculated field based on other fields in the step. | |
Filter | This step is for filtering data in a step. | |
Merge | This step merges two sets of data based on the configured Join Fields. | |
Split | This step duplicates an input dataset to create identical output datasets. | |
| PMML Model Prediction | Downloadable transformation step | This step integrates a PMML model into the platform and applies it on the data. |
| PFA Model Prediction | This step integrates a PFA model and applies it on the data. | |
| H2O Model Prediction | This step integrates a H2O model and applies it on the data. | |
| R Model Prediction | This step integrates a R model and applies it on the data. | |
| Datatype Conversion | Field transformation | |
| Duplicate Field | Field transformation | |
| Number Precision | ||
| Sub-string | ||
| Switch Case | ||
| White Space |