Pivoting (deprecated)

The node counts the co-occurrences of all value pairs between the group and pivot column. If an aggregation column is selected, the value between the co-occurrences is computed based on the selected aggregation method. In the resulting pivot table, the possible values of the group column appear as row IDs and the values of the pivot column as column names. The value in each cell of the table is the aggregation value, either the number of occurrences or the computed aggregation value.

Options

Pivot column

Select a column to find all co-occurrences among the values of the group column. The values of this column define the column header.

Group column

Select a column to perform a grouping on. The column values are then used as row IDs.

Enable aggregation

If selected, the aggregation is performed based on one selected numeric column to which the selected aggregation method is applied.

Aggregation column

Select a numeric column used to aggregate all occurrences of the pivot values within one group.

Aggregation method

If no aggregation column has been selected, simply the numbers of co-occurrences are counted between the group and pivot column. The following methods can be applied to the aggregation column: SUM, MEAN, MIN, MAX, VARIANCE, and STD DEVIATION.

Enable hiliting

Select, if hiliting is enabled between input and output data.

Ignore missing values

Ignore rows containing missing values in pivot column.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers