Icon

SplitFileAndSaveIntoSubfolders

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.

This is my solution.

(RELATIVE,knime.workflow.data,sales_data.csv)Date onlylocale: en_GBExtract Yearand Month (name)locale: en_GBGroupByYear and Month(name)(RELATIVE,knime.workflow.data,file_path_name)ExtractYear and Month(name)only Original ColumnsNode 12file_path_nameString(Year)+"/"+Monath(name)+".csv"Loop over all groupsCSV Reader String to Date&Time Extract Date&TimeFields Group Loop Start String to Path(Variable) Table Rowto Variable Column Filter CSV Writer String Manipulation(Variable) Variable Loop End (RELATIVE,knime.workflow.data,sales_data.csv)Date onlylocale: en_GBExtract Yearand Month (name)locale: en_GBGroupByYear and Month(name)(RELATIVE,knime.workflow.data,file_path_name)ExtractYear and Month(name)only Original ColumnsNode 12file_path_nameString(Year)+"/"+Monath(name)+".csv"Loop over all groupsCSV Reader String to Date&Time Extract Date&TimeFields Group Loop Start String to Path(Variable) Table Rowto Variable Column Filter CSV Writer String Manipulation(Variable) 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: stan
Created at: 2022-02-02
On NodePit since: 2022-02-03
Last update: 2024-04-28
Created with KNIME version: v4.5.1
Tags: #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!