This section provides detailed procedures on the different types of data transformations you could perform.
Yellowfin comes with a set of in-built transformation steps, but additional steps can also be incorporated. This is done via special data science widgets available on the Marketplace 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.
Following is a list of all the transformations you can perform on your data. Click on a transformation name to learn how to use it in your flow.
Transformation | Related Component | Description |
---|---|---|
In-built transformation step | This step transforms your data into a summary form, by applying functions like count, count distinct, sum, average, etc. | |
In-built transformation step | This step creates a calculated field based on other fields in the step. | |
In-built transformation step | This step is for filtering data in a step. | |
In-built transformation step | This step merges two sets of data based on the configured Join Fields. | |
In-built transformation step | 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 | Downloadable transformation step | This step integrates a PFA model and applies it on the data. |
H2O Model Prediction | Downloadable transformation step | This step integrates a H2O model and applies it on the data. |
R Model Prediction | Downloadable transformation step | This step integrates a R model and applies it on the data. |
Datatype Conversion | Field transformation | |
Duplicate Field | Field transformation | |
Number Precision | Field transformation | |
Sub-string | Field transformation | |
Switch Case | Field transformation | |
White Space | Field transformation |