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.