Yellowfin comes with a set of in-built transformation steps, but additional steps can also be incorporated that will apply data science models to data. This is done via special plug-ins available on the Marketplace that support numerous data science outputs such as PMML, PFA, R and H2O. Further transactions can also be performed on data by applying various functions through the data preview panel or the configure panel.
Following is a list of all the transformations that you can perform on your data. Click on a transformation name to learn how to use it in your flow.
Transformation | Type | 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 Conversions | Field transformation | This function is used to convert the datatype of a field into another type. For example, text can be converted into numeric values, SQL date, or SQL timestamp. |
| Duplicate Field | Field transformation | To create a copy of the data field. |
| Number Precision | Field transformation | To round off a numeric value. |
| Sub-string | Field transformation | To extract part of a string. |
| Switch Case | Field transformation | To convert text to all uppercase, all lowercase, or proper case. |
| White Space | Field transformation | To remove white space from data. |