Icon

knime pivot example

Sample DataPivot the table around "EventID", grouping by Objectto generate required tableGenerate "EventID" which is Event#rank.This will be pivotted to become thecolumn namesRank each row in order of counter,grouped by each "Object"Provide an ordinalcounter so that "Rank"can provide an event ranking in ascending order foreach ObjectNot actually necessary, but includedhere to demo thecolumns required bythe Pivoting nodeTable Creator Pivoting String Manipulation Rank Counter Generation Column Filter Sample DataPivot the table around "EventID", grouping by Objectto generate required tableGenerate "EventID" which is Event#rank.This will be pivotted to become thecolumn namesRank each row in order of counter,grouped by each "Object"Provide an ordinalcounter so that "Rank"can provide an event ranking in ascending order foreach ObjectNot actually necessary, but includedhere to demo thecolumns required bythe Pivoting nodeTable Creator Pivoting String Manipulation Rank Counter Generation Column Filter

Nodes

Extensions

Links

Download

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

Download Workflow
Created by: brian
Created at: 2021-12-13
On NodePit since: 2022-02-06
Last update: 2024-05-02
Created with KNIME version: v4.5.0

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

Try NodePit Runner!