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.
The Merge transform allows values from two or more columns to be merged into a single column.
The Null Replacement transform allows for the replacing of input data with user-specified values when null values are found.
This transform returns the specified percentage out of the full set of input records using 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 Python Analysis transform lets you write scripts using the Python programming language to perform analysis on data.
The Python Data Generator transform lets you generate data by writing scripts using the Python programming language.
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 ranks your data and adds the rank number to your input.
The Record Sampling transform returns the specified number of records out of the full set of records by random selection.
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 Top/Bottom transform filters the records to contain the top or bottom 'N' number of records as ranked by the columns you select.
The Transpose transform lets you turn columns into rows and rows into columns.
The Unpivot transform combines multiple columns into a single column with multiple rows (opposite of Pivot).
The Process Result transform represents the final output or result of the data cube (ETL process).