The Aggregate transform allows use of aggregate functions such as sum, average, count, minimum, maximum, etc.

The Calculated Element transform lets you create new elements by writing DundasScript expressions. 

The Data Conversion transform allows you to change the data type of a column.

The Filter transform filters out rows that do not meet the configured criteria/settings.

The Join transform combines two separate tables together by matching up their rows. All of the columns from both tables can be included.

The Lookup transform replaces the values of one or more key columns with the values you choose in another table.

The Math transform lets you perform simple math functions such as Absolute, Round, and Square Root on numeric input columns.

The String transform manipulates string columns by applying string functions.

The Union transform combines the rows from two tables that have matching columns.

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

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