Icon

Challenge2-SplitFileSaveSubfolder

justknimeit-2
Read CSV file and change data type for column with date values Start loop to create folder directory list using flow variables Export each CSv file using CSV writer node to current KNIME workflow inmultiple loop iterations Challenge 2: Split File and Save into SubfoldersDataset: https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%202%20-%20Dataset~qINPhTj97JNHoJLP/Task: Split the data into monthly CSV files and to save them into different subfolders, where each subfolder corresponds to a year ie Year/ Month(name).csv Read sales_data.csv using relative to workflow areaConvert "Sales Date" to Date & Time Split Date to extract Year & Monthstart loop to group months by yearinclude complusory columns write all the new folder to the KNIME workspace mount append string tyoe variable titled path taking the form Year/Month.csvNode 11End loop to iterate the process for each year and monthRename "Datum" columnCSV Reader String to Date&Time Extract Date&TimeFields Group Loop Start Column Filter CSV Writer String Manipulation(Variable) String to Path(Variable) Variable Loop End Column Rename Read CSV file and change data type for column with date values Start loop to create folder directory list using flow variables Export each CSv file using CSV writer node to current KNIME workflow inmultiple loop iterations Challenge 2: Split File and Save into SubfoldersDataset: https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Datasets/latest/Challenge%202%20-%20Dataset~qINPhTj97JNHoJLP/Task: Split the data into monthly CSV files and to save them into different subfolders, where each subfolder corresponds to a year ie Year/ Month(name).csv Read sales_data.csv using relative to workflow areaConvert "Sales Date" to Date & Time Split Date to extract Year & Monthstart loop to group months by yearinclude complusory columns write all the new folder to the KNIME workspace mount append string tyoe variable titled path taking the form Year/Month.csvNode 11End loop to iterate the process for each year and monthRename "Datum" columnCSV Reader String to Date&Time Extract Date&TimeFields Group Loop Start Column Filter CSV Writer String Manipulation(Variable) String to Path(Variable) Variable Loop End Column Rename

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: Morpheus
Created at: 2022-02-03
On NodePit since: 2022-02-04
Last update: 2024-11-17
Created with KNIME version: v4.4.4
Tags: #justknimeit-2#justknimeit#knime

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

Try NodePit Runner!