The Copy Element transform creates new columns by copying selected input columns and adding the new columns to the output.
The Fuzzy Grouping transform allows grouping of records by looking at the similarity between the values of various columns.
The Fuzzy Lookup transform joins the columns of two tables into one table by matching key values, where they may not match exactly between the two tables.
This transform returns the specified percentage out of the full set of input records using random selection.
The Record Sampling transform returns the specified number of records out of the full set of records by random selection.
The Pivot transform allows you to create new columns out of rows in your input that contain a corresponding set of values.
The Unpivot transform combines multiple columns into a single column with multiple rows (opposite of Pivot).
The Rank transform ranks your data and adds the rank number to your input.
The Top/Bottom transform filters the records to contain the top or bottom 'N' number of records as ranked by the columns you select.
The R Data Generator transform lets you generate data by writing scripts using the R statistical programming language.
The R Language Analysis transform lets you write scripts using the R programming language to perform statistical and predictive analysis on data.
The Remove Duplicates transform lets you remove duplicated records by grouping all of the selected input columns and copying the results to the output.
The Sort transform allows various sorting rules to be applied sort the input data.
The Null Replacement transform allows for the replacing of input data with user-specified values when null values are found.
The Transpose transform lets you turn columns into rows and rows into columns.
The Data Input transform lets you reference a warehouse data storage area containing user input data.
The Python Data Generator transform lets you generate data by writing scripts using the Python programming language.
The Python Analysis transform lets you write scripts using the Python programming language to perform analysis on data.
The Merge transform allows values from two or more columns to be merged into a single column.