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…

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

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…

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

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

This node converts alphanumeric characters to lowercase or UPPERCASE.

Groups the selected columns per row and aggregates their cells using the selected aggregation method. To change the name of the n…

Combines the content of a set of columns and appends the concatenated string as separate column to the input table. The user need…

Creates a new table with a single row or column containing the column names. The node has two output tables: The first table cont…

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