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 Top/Bottom transform is used to set up rules on how data should be sorted and how many records are to be returned (combination of Sort transform and Record Sampling transform without the random generation).

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.

The Unpivot transform allows combining multiple columns into a single column (opposite of Pivot).

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri