Icon

05_​Pivoting_​in_​Databases

Database Pivot

This workflow creates an SQL statement that generates a pivot table.

A pivot table allows you to quickly summarize your data based on a pivot, aggregation and value columns.

This workflow creates an SQL statement that generates a pivot table. Pivot data within the database. Look at the result once the node is executed by opening the " Pivoted DB Data" view via the context menu and clicking the "Cache no. of rows" buttonRead result intoKNIME Analytics Platform Create ExampleTable DB Pivot DB Reader This workflow creates an SQL statement that generates a pivot table. Pivot data within the database. Look at the result once the node is executed by opening the " Pivoted DB Data" view via the context menu and clicking the "Cache no. of rows" buttonRead result intoKNIME Analytics PlatformCreate ExampleTable DB Pivot DB Reader

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Berthold
Created at: 2015-12-08
On NodePit since: 2019-07-12
Last update: 2026-07-10
Created with KNIME version: v4.1.0
Tags: databasepivoting

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

Try NodePit Runner!