Preparation

Link
Blue circle with four white dots at north, south east and west. Four arrows start from the middle and point to the dots.

Select Records Tool

This tool returns records and ranges of records that are specified,
Link
Record ID Tool Icon

Record ID Tool

This tool creates a new column and assigns a unique identifier for each record in the data.
Link
Oversample Field Tool Icon

Oversample Field Tool

This tool allows for data with high negative responses to become normalized.
Link
Multi-Field Binning Tool Icon

Multi-Field Binning Tool

This tool allows a user to tile or bin on multiple fields.
Link
Imputation Tool Icon

Imputation Tool

The Imputation tool gives the user the ability to replace a values in numeric data fields.
Link
Create Samples Tool Icon

Create Samples Tool

Split the input records into two or three random samples.
Link
Blue circle with three white circles inside that are in a line increasing in size from left to right.

Sort Tool

This tool arranges the records in a table in alphanumeric order based on the values of data.
Link
Random % Sample Tool

Random % Sample Tool

Returns a random sample of the incoming data stream.
Link
Blue circle with white snowflake inside.

Unique Tool

This tool distinguishes whether a data record is unique or a duplicate based on specified fields.
Link
Blue circle with three white circles inside that are in a line increasing in size from left to right.

Sort Tool

This tool arranges the records in a table in alphanumeric order based on the values of data.
Link
Blue circle with three white circles inside that are in a line increasing in size from left to right.

Sort Tool

This tool arranges the records in a table in alphanumeric order based on the values of data.
Link
Blue circle with four white dots at north, south east and west. Four arrows start from the middle and point to the dots.

Select Records Tool

This tool returns records and ranges of records that are specified,
Link
Three partially full beakers

Sample Tool

This tool limits the data stream to a specified number, percentage, or random set of the rows.
Link
Three partially full beakers

Sample Tool

This tool limits the data stream to a specified number, percentage, or random set of the rows.
Link
Record ID Tool Icon

Record ID Tool

This tool creates a new column and assigns a unique identifier for each record in the data.
Link
Oversample Field Tool Icon

Oversample Field Tool

This tool allows for data with high negative responses to become normalized.
Link
Liquid drops falling into a beaker.

Multi-Row Formula Tool

This tool uses expressions to create and update columns by using row data to create formulas.
Link
Beaker with liquid and stir-stick.

Multi-Field Formula Tool

The Multi-Field Formula tool creates or updates multiple fields using a single expression.
Link
Blue circle with a white square in the middle that is comprised of 9 smaller squares in a 3-by-3 configuration.

Tile Tool

This tool uses user specified methods to assign a value (tile) based on ranges in the data.
Link
Multi-Field Binning Tool Icon

Multi-Field Binning Tool

This tool allows a user to tile or bin on multiple fields.
Link
Imputation Tool Icon

Imputation Tool

The Imputation tool gives the user the ability to replace a values in numeric data fields.
Link
Box with rows, a plus sign and an arrow pointing downward.

Generate Rows Tool

The Generate Rows tool creates new rows of data at the record level.
Link
Beaker with bubbling liquid

Formula Tool

The Formula Tool uses expressions to create and update columns.
Link

Select Tool

The Select tool includes, excludes, and reorders the columns of data that pass through a workflow.
Link

Select Tool

The Select tool includes, excludes, and reorders the columns of data that pass through a workflow.
Link
Filter Tool Icon

Filter Tool

Query records by using an expression and split data into two outputs: True or False.
Link
Data Cleansing Tool Icon

Data Cleansing Tool

Fix common data quality issues including nulls and unwanted characters. Modify case.
Link
Create Samples Tool Icon

Create Samples Tool

Split the input records into two or three random samples.
Link
Auto Field Tool Icon

Auto Field Tool

Set the field type to the smallest possible size relative to the data contained within the column.