Pivot

Options

Group settings

Group columns

Select one or more columns according to which the group rows are created.

Pivot settings

Pivot columns

Select one or more columns according to which the pivot columns are created.

Ignore missing values

Ignore rows containing missing values in pivot column.

Append overall totals

Appends the overall pivot totals with each aggregation performed together on all selected pivot columns.

Ignore domain

Ignore domain and use only the possible values available in the input data.

Manual Aggregation

Aggregation methods

Select one or more columns for aggregation from the available columns list. Change the aggregation method in the Aggregation column of the table. You can add the same column multiple times. In order to change the aggregation method of more than one column select all columns to change, open the context menu with a right mouse click and select the aggregation method to use. Tick the missing box to include missing values. This option might be disabled if the aggregation method does not support missing values. The parameter column shows an "Edit" button for all aggregation operators that require additional information. Clicking on the "Edit" button opens the parameter dialog which allows changing the operator specific settings.

Advanced settings

Column name

The name of the resulting pivot column(s) depends on the selected naming schema.

• Pivot name+Aggregation name: Uses the pivot name first and the aggregation name second joint by a + character. Keeps the original column names. Note that you can use all aggregation columns only once with this column naming option to prevent duplicate column names.
• Aggregation name+Pivot name: Uses the aggregation name first and the pivot name second joint by a + character.
• Pivot name: Uses solely the pivot name. Note that this option solely supports the selection of a single aggregation method to ensure uniqueness of the column names.

Aggregation name

The name of the resulting aggregation column(s) depends on the selected naming schema.

• Keep original name(s): Keeps the original column names. Note that you can use all aggregation columns only once with this naming option to prevent duplicated column names.
• Aggregation method (column name): Uses the aggregation method first and appends the column name in brackets
• Column name (aggregation method): Uses the column name first and appends the aggregation method in brackets

All aggregation methods get an * appended if the missing value option is not ticked in the aggregation settings in order to distinguish between columns that considered missing values in the aggregation process and columns that do not.

Sort lexicographically

Lexicographically sorts all columns belonging to the same logical group, i.e., pivots (aggregations), groups, and overall totals.

Maximum unique values per group

Defines the maximum number of unique values per group to avoid problems with memory overloading. All groups with more unique values are skipped during the calculation and a missing value is set in the corresponding column, and a warning is displayed.

Value delimiter

The value delimiter used by aggregation methods such as concatenate.

Process in memory

Process the table in the memory. Requires more memory but is faster since the table needs not to be sorted prior aggregation. The memory consumption depends on the number of unique groups and the chosen aggregation method. The row order of the input table is automatically retained.

Retain row order

Retains the original row order of the input table. Could result in longer execution time. The row order is automatically retained if the process in memory option is selected.

Enable hiliting

If enabled, the hiliting of a group row will hilite all rows of this group in other views. Depending on the number of rows, enabling this feature might consume a lot of memory.

Missing

Missing values are considered during aggregation if the missing option is ticked for the corresponding row in the column aggregation table. Some aggregation methods do not support the changing of the missing option such as means.

Views

This node has no views

Workflows

• _01_PMR_AnalysisKNIME Hub
• 0. Lubes_Sales_Pred-ModelNodePit Space
• 0. Lubes_Sales_Pred-ModelNodePit Space
• 00 Main MenuKNIME Hub
• 00 Main MenuKNIME Hub
• Show all 2910 workflows

Links

• Please Help: How to Add Columns toby danielesser on 2020-06-06

  forum.knime.com/p/93580
• How to replace multiple values in different columnsby armingrudd on 2019-10-07

  forum.knime.com/p/71840
• how to merge tables, one with single instance and the other with multiple instances for a unique IDby armingrudd on 2019-09-26

  forum.knime.com/p/71082
• Crear Tabla - Nodeby knimediger on 2021-08-20

  forum.knime.com/p/132475
• Loop and Join while filtering different row informationby armingrudd on 2019-12-12

  forum.knime.com/p/76809
• Show all 20 links

Developers