The Aggregate transform allows use of aggregate functions such as SUM, AVG, COUNT, MIN, MAX, etc.
The Calculated Element transform is created when a structure is dragged onto the canvas from a data connector that supports relational queries.
The Data Conversion transform allows change of data type of a column to another data type.
The Filter transform filters out rows that do not meet the configured criteria/settings.
The Join transform allows joining two tables by defining the keys and specifying the join type. If relationship exists between the two tables, the link is automatically created, but can be changed if necessary.
The Lookup transform joins data from input columns with column in a lookup table.
The Math transform lets you perform simple math functions such as Absolute, Ceiling, and Square Root on numeric input columns.
The String transform manipulates string columns in data tables by applying sting functions.
The Union transform combines data from multiple structures by mapping columns onto one another.