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

Error rendering macro 'rw-search'

null

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.
Date ComponentBuilt-in transformation stepThis step extracts specific date elements from date fields.
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 Set of functions used to convert the datatype data type 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 Generate GeoPoint values based on geographical data.
Duplicate FieldInline Field transformationTo create Create a copy of the data field.
Number PrecisionInline Field transformationTo round Round off a numeric value.
Sub-stringInline Field transformationTo extract Extract part of a string.
Switch CaseInline Field transformationTo convert Convert text to all uppercase, all lowercase, or proper case.
White SpaceInline Field transformationTo remove Remove white space from data.
Find and ReplaceInline Field transformationTo search Search for specific data values and replace them with other values.
Grouped DataInline Field transformationGroup a field's values.