The Data Input transform lets you reference a warehouse data storage area containing user input data.
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.
The Null Replacement transform allows for the replacing of input data with user-specified values when Null values are found.
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 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 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 Rank transform allows for a rank number to be assigned to a new element created by the transform.
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 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 Transpose transform lets you turn columns into rows and rows into columns.