Icon

Splitting multiple rows by column value to append according to year and month

input filegroup per yearmonthtemp cleanupcollections per year/monthcreatedata collectionsort on year monthSplit collection vs non-collection columnsStart LoopDo the splitting End Looprename each elementmergeclean-up header Excel Reader GroupBy Row Filter Split CollectionColumn Create CollectionColumn Sorter Column Splitter Column ListLoop Start Split CollectionColumn Loop End (ColumnAppend) Column Rename Column Appender Column Rename(Regex) input filegroup per yearmonthtemp cleanupcollections per year/monthcreatedata collectionsort on year monthSplit collection vs non-collection columnsStart LoopDo the splitting End Looprename each elementmergeclean-up header Excel Reader GroupBy Row Filter Split CollectionColumn Create CollectionColumn Sorter Column Splitter Column ListLoop Start Split CollectionColumn Loop End (ColumnAppend) Column Rename Column Appender Column Rename(Regex)

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: arjen
Created at: 2022-06-30
On NodePit since: 2022-07-01
Last update: 2024-04-26
Created with KNIME version: v4.5.2

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

Try NodePit Runner!