Icon

Split File and Save into Subfolders

Split File and Save into Subfolders
Challenge 2: Split File and Save into SubfoldersA pharmaceutical company used to keep its sales data in a CSV file. They ask for your help to split the datainto monthly CSV files and to save them into different subfolders, where each subfolder corresponds to ayear. As an example, the data for January 2015 should be stored in a file named 2015/January.csv. In yoursolution, remember to save the files and subfolders in the workflow data folder. read data about saleschange date colto date typeexttract year and monthgroop order year and monthcreate variable to pathfilter columnswrite the filesjoin year and monthto the pathchange the path to path typeNode 12 CSV Reader String to Date&Time Extract Date&TimeFields Group Loop Start Table Rowto Variable Column Filter CSV Writer String Manipulation String to Path Variable Loop End Challenge 2: Split File and Save into SubfoldersA pharmaceutical company used to keep its sales data in a CSV file. They ask for your help to split the datainto monthly CSV files and to save them into different subfolders, where each subfolder corresponds to ayear. As an example, the data for January 2015 should be stored in a file named 2015/January.csv. In yoursolution, remember to save the files and subfolders in the workflow data folder. read data about saleschange date colto date typeexttract year and monthgroop order year and monthcreate variable to pathfilter columnswrite the filesjoin year and monthto the pathchange the path to path typeNode 12CSV Reader String to Date&Time Extract Date&TimeFields Group Loop Start Table Rowto Variable Column Filter CSV Writer String Manipulation String to Path 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: amapper
Created at: 2022-06-27
On NodePit since: 2022-06-30
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: JustKnimeIt-2JustKnimeIt

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

Try NodePit Runner!