This node takes a list of user-defined rules and tries to match them to each row in the input table. If a rule matches, its outco…

Allows to perform several column transformations on any number of input tables such as renaming, filtering, re-ordering and type …

Groups the rows of a table by the unique values in the selected group columns. A row is created for each unique set of values of …

This node combines two tables similar to a join in a database. It combines each row from the top input port with each row from th…

Manipulates strings like search and replace, capitalize or remove leading and trailing white spaces. Examples: To remove leading …

The Math Formula (Multi Column) node is an extension of the Math Formula node which evaluates a mathematical expression based on …

Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will…

The String Manipulation (Multi Column) node is an extension of the String Manipulation node, applying the provided expression to …

The Table Difference Finder offers the functionality to compare two tables by means of their values and table specs. Firstly, the…

This node changes the order of the input columns, based on user defined settings. Columns may be shifted in single steps left or …

This node identifies duplicate rows. Duplicate rows have identical values in certain columns. The node chooses a single row for e…

The number of rows and columns of the input table are extracted and written to the output table. The output table consists of two…

This node evaluates a mathematical expression based on the values in a row. The computed results can be either appended as new co…

For each group an individual ranking is computed based on the selected ranking attribute(s) and ranking mode. The user must provi…

Node extracting the meta information from the input table (column names, types, etc.) The meta information is referred to as the …

This node converts alphanumeric characters to lowercase or UPPERCASE.

Renames all columns based on a regular expression search & replace pattern. The search pattern is a regular expression, possibly …

Scans the data and updates the possible values list and/or the min- and max values of selected columns. This node is useful when …

Creates new table with a single row containing the column names. The node has two outports: The first port contains the column he…

Updates column names of a table according to the mapping in second dictionary table. The dictionary table needs to contain two co…