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 String transform manipulates string columns by applying string functions.

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

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

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:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri