DB Pivot

This node pivots the input DB Data table using the selected of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns for each unique set of column combinations together with each aggregation method.

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.

A detailed description of the available aggregation methods can be found on the 'Description' tab in the node dialog.

Options

Groups

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

Pivot

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

Manual Aggregation

Aggregation settings
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. 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 column naming option to prevent duplicate 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.

Input Ports

Icon
DB Data to apply pivoting.

Output Ports

Icon
DB Data with pivoted rows.

Popular Predecessors

Popular Successors

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.

Installation

To use this node in KNIME, install the extension KNIME Database from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 5.3.2.v202409010954
On NodePit since: 2024-07-09
Last update: 2024-11-21
KNIME versions: Since v3.6

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!