Icon

Expand Ranges and tabulate data

There has been no description set for this workflow's metadata.

Node 1Split to list of year rangesdelimited by commaMake a row for each "element"Split rangesdelimited by -into columnsrename colsto Year Startand Year EndCount of years in rangepopulate missingvalues in Year Endusing Year Startcreate a rowfor each yearin rangeDefine yearfor rowAllocatesequentialnumber to eachyear in rangeTabulate the yearsduplicate the yearfor the rowso it can be both used aspivot name, and pivot dataTable Creator Cell Splitter Ungroup Cell Splitter Column Rename Math Formula Column Merger One Row to Many Math Formula Rank Pivoting Rule Engine Node 1Split to list of year rangesdelimited by commaMake a row for each "element"Split rangesdelimited by -into columnsrename colsto Year Startand Year EndCount of years in rangepopulate missingvalues in Year Endusing Year Startcreate a rowfor each yearin rangeDefine yearfor rowAllocatesequentialnumber to eachyear in rangeTabulate the yearsduplicate the yearfor the rowso it can be both used aspivot name, and pivot dataTable Creator Cell Splitter Ungroup Cell Splitter Column Rename Math Formula Column Merger One Row to Many Math Formula Rank Pivoting Rule Engine

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: BATEB031
Created at: 2024-02-05
On NodePit since: 2024-02-06
Last update: 2024-04-28
Created with KNIME version: v4.7.8

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

Try NodePit Runner!