Icon

Just Knime It Challenge 2

Just Knime It Challenge 2
Pre-Process Data Create Loop Tables forYears and Month Outer Loop to loop through each year and Filter Data Set for each year, pass data to inner loop Inner Loop to filter yearly data for each month, then save in right locationwith right name Read DataSplit datum columnMonth No to Month Name MappingJoin in Month NamesTidy up helper ColsRename Year ColUnique Year-Mon PairsUnique YearsLoop through each yearFilter Year-Mon Pair for YearLoop through each MonthFilter Main Data Set For YearFilter for MonthRemove create colsEnd Month LoopEnd Year LoopWrite FileNode 24Create File Path StrConvert Str to Path CSV Reader Cell Splitter Table Creator Joiner Column Filter Column Rename GroupBy GroupBy Table Row ToVariable Loop Start Row Filter Table Row ToVariable Loop Start Row Filter Row Filter Column Filter Loop End Loop End CSV Writer Number To String String Manipulation(Variable) String to Path(Variable) Pre-Process Data Create Loop Tables forYears and Month Outer Loop to loop through each year and Filter Data Set for each year, pass data to inner loop Inner Loop to filter yearly data for each month, then save in right locationwith right name Read DataSplit datum columnMonth No to Month Name MappingJoin in Month NamesTidy up helper ColsRename Year ColUnique Year-Mon PairsUnique YearsLoop through each yearFilter Year-Mon Pair for YearLoop through each MonthFilter Main Data Set For YearFilter for MonthRemove create colsEnd Month LoopEnd Year LoopWrite FileNode 24Create File Path StrConvert Str to Path CSV Reader Cell Splitter Table Creator Joiner Column Filter Column Rename GroupBy GroupBy Table Row ToVariable Loop Start Row Filter Table Row ToVariable Loop Start Row Filter Row Filter Column Filter Loop End Loop End CSV Writer Number To String String Manipulation(Variable) String to Path(Variable)

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: marti
Created at: 2022-02-03
On NodePit since: 2022-02-04
Last update: 2024-11-18
Created with KNIME version: v4.5.0
Tags: justknimeitjustknimeit2#justknimeit#justknimeit-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!