Icon

KNIME_​challenge2_​solution

Challenge 2: Split File and Save into SubfoldersLevel: EasyDescription: A 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 a year. As anexample, the data for January 2015 should be stored in a file named 2015/January.csv. In your solution, remember to savethe files and subfolders in the workflow data folder. Define relative path and folder structure Node 31Node 32Node 33Node 35Node 39Node 42Node 44Node 45Node 46Node 47 CSV Reader Column Expressions String to Date&Time Group Loop Start CSV Writer Variable Loop End Column Filter Table Rowto Variable String to Path(Variable) VariableExpressions Challenge 2: Split File and Save into SubfoldersLevel: EasyDescription: A 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 a year. As anexample, the data for January 2015 should be stored in a file named 2015/January.csv. In your solution, remember to savethe files and subfolders in the workflow data folder. Define relative path and folder structure Node 31Node 32Node 33Node 35Node 39Node 42Node 44Node 45Node 46Node 47 CSV Reader Column Expressions String to Date&Time Group Loop Start CSV Writer Variable Loop End Column Filter Table Rowto Variable String to Path(Variable) VariableExpressions

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: MMU
Created at: 2022-02-03
On NodePit since: 2022-02-11
Last update: 2024-11-21
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!