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 allows searching for a matching recording from a secondary table when no relationship key fields are defined between two tables.
By specifying a rate, this transform reads in all of the data from the previous transform and generates a set of random indexes according to the rate input multiplied by the total record count.
The Record Sampling transform reads in all of the data from the previous transform and generates a set of random indexes according to the number input. Then output the records according to those indexes.
The Pivot transform allows for the creation of new columns and transposing data into a new layout. It can be used to make results more compact by pivoting the input data on a column value.
The Rank transform allows for a rank number to be assigned to a new element created by the transform.
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 to the input columns and copies the results to the output.
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.