Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Transformation

Type

Description

Aggregate

Built-in transformation step

This step transforms your data into a summary form, by applying functions like count, count distinct, sum, average, etc.

Calculated Field

Built-in transformation step

This step creates a calculated field based on other fields in the step.

Filter

Built-in transformation step

This step is for filtering data in a step.

Merge

Built-in transformation step

This step merges two sets of data based on the configured Join Fields.

Split

Built-in transformation step

This step duplicates an input dataset to create identical output datasets.

PMML Model PredictionDownloadable transformation stepThis step integrates a model saved as a PMML model file into the platform and applies it on the data.
PFA Model PredictionDownloadable transformation stepThis step integrates a PFA model and applies it on the data.
H2O Model PredictionDownloadable transformation stepThis step integrates a model created in H2O model .ai and applies it on the data.
R Model PredictionDownloadable transformation stepThis step integrates a an R model and applies it on the data.
Datatype ConversionsField transformationThis 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 FieldField transformationTo create a copy of the data field.
Number PrecisionField transformationTo round off a numeric value.
Sub-stringField transformationTo extract part of a string.
Switch CaseField transformationTo convert text to all uppercase, all lowercase, or proper case.
White SpaceField transformationTo remove white space from data.

...