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.

UnionBuilt-in transformation stepThis step combines the data from two steps together.
PitneyBowes Forward GeocodingDownloadable transformation step

This step uses the PitneyBowes forward geocoding API to convert address values into location coordinates.

OpenCage Forward GeocodingDownloadable transformation stepUses the OpenCage forward geocoding API to convert address values into location coordinates.
PMML Model PredictionDownloadable transformation stepThis step integrates a model saved as a PMML 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.ai and applies it on the data.
R Model PredictionDownloadable transformation stepThis step integrates an R model and applies it on the data.
Data Type ConversionsInline Field 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.
GeoPoint ConversionData type conversionTo generate GeoPoint values based on geographical data.
Duplicate FieldInline Field transformationTo create a copy of the data field.
Number PrecisionInline Field transformationTo round off a numeric value.
Sub-stringInline Field transformationTo extract part of a string.
Switch CaseInline Field transformationTo convert text to all uppercase, all lowercase, or proper case.
White SpaceInline Field transformationTo remove white space from data.

...