Preparation
![Auto Field Tool Icon](../../image/uuid-b7347050-71b7-b0da-cd14-6420f0a8eca9.png)
Set the field type to the smallest possible size relative to the data contained within the column.
![Create Samples Tool Icon](../../image/uuid-d9dbacd2-86eb-4467-ff7c-5735a71337d8.png)
Split the input records into two or three random samples.
![Data Cleansing Tool Icon](../../image/uuid-cfeca2cb-88f4-427c-c466-b795bae554ee.png)
Fix common data quality issues including nulls and unwanted characters. Modify case.
![Filter Tool Icon](../../image/uuid-69122228-92d1-770a-c737-0ffe904b58ad.png)
Use Filter to select data using a condition. Rows of data that meet the condition are output to the True anchor.
![Beaker with bubbling liquid](../../image/uuid-9dc01e86-c9f6-f365-2a11-4528d15c7499.png)
The Formula Tool uses expressions to create and update columns.
![Box with rows, a plus sign and an arrow pointing downward.](../../image/uuid-e091bf0c-d71a-0744-36a1-225f0642e223.png)
The Generate Rows tool creates new rows of data at the record level.
![Imputation Tool Icon](../../image/uuid-19990a6e-a37c-9d9c-d815-532cb43b27fc.png)
The Imputation tool gives the user the ability to replace a values in numeric data fields.
![Multi-Field Binning Tool Icon](../../image/uuid-b6d7571b-8a9a-4cd6-8033-101911252e73.png)
This tool allows a user to tile or bin on multiple fields.
![Beaker with liquid and stir-stick.](../../image/uuid-8695ee18-29e6-83c9-a416-70fe872f4f28.png)
The Multi-Field Formula tool creates or updates multiple fields using a single expression.
![Liquid drops falling into a beaker.](../../image/uuid-2289fa1b-cf9c-8c71-ed53-b15c8c57c92e.png)
This tool uses expressions to create and update columns by using row data to create formulas.
![Oversample Field Tool Icon](../../image/uuid-3d0be916-d02e-fcb8-2695-e5d5b4cedc19.png)
This tool allows for data with high negative responses to become normalized.
![Random % Sample Tool](../../image/uuid-b4b16910-3ed6-7de0-76d7-de55a231c245.png)
Returns a random sample of the incoming data stream.
![Record ID Tool Icon](../../image/uuid-915aa92e-03af-6633-3a22-cdf42b45f1a0.png)
Use Record ID to create a new column in the data and assign a unique identifier, that increments sequentially, for each row in the data.
![Three partially full beakers](../../image/uuid-e4c37b60-0dbb-9718-a7dd-b642c9e0a5c0.png)
This tool limits the data stream to a specified number, percentage, or random set of the rows.
![Blue circle with four white dots at north, south east and west. Four arrows start from the middle and point to the dots.](../../image/uuid-11ca1cac-34fc-7ae1-ee72-ec8be54a4f3b.png)
This tool returns records and ranges of records that are specified,
![Blue circle with a white dot, a checkmark and another dot in a line.](../../image/uuid-d779826a-75e6-81f3-2e95-4c92c87cad7b.png)
The Select tool includes, excludes, and reorders the columns of data that pass through a workflow.
![Blue circle with three white circles inside that are in a line increasing in size from left to right.](../../image/uuid-a2f4af98-8265-6ce1-2f10-7f0a2ee4c737.png)
Use Sort to arrange the rows in a table in alphanumeric order based on the values of the specified data columns.
![Blue circle with a white square in the middle that is comprised of 9 smaller squares in a 3-by-3 configuration.](../../image/uuid-ebb9b55d-8fc2-ff65-3453-d62be1bc2184.png)
This tool uses user specified methods to assign a value (tile) based on ranges in the data.
![Blue circle with white snowflake inside.](../../image/uuid-95081251-d8eb-14fc-ddb0-4307f66faa81.png)
This tool distinguishes whether a data record is unique or a duplicate based on specified fields.