Icon

Challenge_​2_​v2

Challenge_2_v2
Create custom file path Year-Month wise Create Subfolders Year wise read dataextract date fieldsID creationYear-monthtake one month dataremove Join Idscreate path relative to workflow data areaCreate one folderper iterationControl the pathwith the flow variableNode 17Year wiseNode 34 CSV Reader Extract Date&TimeFields String Manipulation GroupBy Chunk Loop Start Joiner Column Filter String to Path Table Row ToVariable Loop Start Create Folder Variable Loop End GroupBy Number To String Table Rowto Variable String Manipulation(Variable) URL to File Path Table Rowto Variable Variable toTable Row CSV Writer String to Path(Variable) String to Date&Time Variable Loop End Create custom file path Year-Month wise Create Subfolders Year wise read dataextract date fieldsID creationYear-monthtake one month dataremove Join Idscreate path relative to workflow data areaCreate one folderper iterationControl the pathwith the flow variableNode 17Year wiseNode 34 CSV Reader Extract Date&TimeFields String Manipulation GroupBy Chunk Loop Start Joiner Column Filter String to Path Table Row ToVariable Loop Start Create Folder Variable Loop End GroupBy Number To String Table Rowto Variable String Manipulation(Variable) URL to File Path Table Rowto Variable Variable toTable Row CSV Writer String to Path(Variable) String to Date&Time Variable Loop End

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: mpatt
Created at: 2022-02-02
On NodePit since: 2022-02-03
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: #justknimeit-2#justknimeit#dataengineering#csv#challenge2

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

Try NodePit Runner!