Icon

Write multiple CSV files to multiple folders

Description: A pharmaceutical company used to keep its sales data in a CSV file. They ask for your help to split the data into monthly CSV files and to save them into different subfolders,where each subfolder corresponds to a year. As an example, the data for January 2015 should be stored in a file named 2015/January.csv. In your solution, remember to save thefiles and subfolders in the workflow data folder. Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10 File Reader Extract Date&TimeFields String to Date&Time Table Row ToVariable Loop Start Rule-basedRow Filter CSV Writer VariableExpressions String to Path(Variable) Variable Loop End DuplicateRow Filter Description: A pharmaceutical company used to keep its sales data in a CSV file. They ask for your help to split the data into monthly CSV files and to save them into different subfolders,where each subfolder corresponds to a year. As an example, the data for January 2015 should be stored in a file named 2015/January.csv. In your solution, remember to save thefiles and subfolders in the workflow data folder. Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10 File Reader Extract Date&TimeFields String to Date&Time Table Row ToVariable Loop Start Rule-basedRow Filter CSV Writer VariableExpressions String to Path(Variable) Variable Loop End DuplicateRow 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: DT232993
Created at: 2022-02-03
On NodePit since: 2022-02-04
Last update: 2024-04-28
Created with KNIME version: v4.5.1

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

Try NodePit Runner!