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

Links