Icon

Challenge 2 - Split File and Save Into Subfolders

Split File and Save Into Subfolders - Solution

Solution to Just KNIME It! challenge #2.

Reads sales dataExtracts year tocreate foldersand months forfilenamesConverts String containingdates to Date typeThe Group Loop gets all rows for agiven month ofa giver year at onceThe year at the 1st rowbecomes a path flow variableConverts year (Integer)to String to create folder pathsA path to a filenameis created with year andmonth dataCreates paths with yearsData is written toCSV fileGroup Loop is closedRemoves Year and Month columnsCSV Reader Extract Date&TimeFields String to Date&Time Group Loop Start Table Rowto Variable Number To String Create File/FolderVariables String to Path CSV Writer Variable Loop End Column Filter Reads sales dataExtracts year tocreate foldersand months forfilenamesConverts String containingdates to Date typeThe Group Loop gets all rows for agiven month ofa giver year at onceThe year at the 1st rowbecomes a path flow variableConverts year (Integer)to String to create folder pathsA path to a filenameis created with year andmonth dataCreates paths with yearsData is written toCSV fileGroup Loop is closedRemoves Year and Month columnsCSV Reader Extract Date&TimeFields String to Date&Time Group Loop Start Table Rowto Variable Number To String Create File/FolderVariables String to Path CSV Writer Variable Loop End Column 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: emilio.silvestri
Created at: 2021-08-13
On NodePit since: 2022-02-06
Last update: 2024-11-18
Created with KNIME version: v4.5.0
Tags: justknimeitjustknimeit-2#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!