Icon

Just Knime It Week2 v.1

Just Knime It Week2 v.1
Just Knime ItChallenge 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 data into monthly CSV files and to save them into different subfolders,where each subfolder corresponds to a year. As an example, the data for January 2015 should be stored in a file named 2015/January.csv. In your solution, remember to save the files andsubfolders in the workflow data folder.Author: Emilio SilvestriDataset: Sales Data in the KNIME HubOur solution will appear here next Tuesday. In the meantime, feel free to discuss your work on the KNIME forum or on social media using the hashtag #justknimeit. Remember to upload yoursolution with tag #justknimeit-2 to your public space on the KNIME Hub. UploadfileConvert date 1Convert date 2Extractyear + monthFilename for groupsYear to stringExtractmonth dataPreparefile name 1Preparefile name 2Save csvfilesGet pathfor CSV writerLoop EndTidy up CSV Reader String to Date/Time(legacy) Legacy Date&Timeto Date&Time Extract Date&TimeFields String Manipulation Number To String Group Loop Start Table Rowto Variable String Manipulation(Variable) CSV Writer String to Path(Variable) Loop End Column Filter Just Knime ItChallenge 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 data into monthly CSV files and to save them into different subfolders,where each subfolder corresponds to a year. As an example, the data for January 2015 should be stored in a file named 2015/January.csv. In your solution, remember to save the files andsubfolders in the workflow data folder.Author: Emilio SilvestriDataset: Sales Data in the KNIME HubOur solution will appear here next Tuesday. In the meantime, feel free to discuss your work on the KNIME forum or on social media using the hashtag #justknimeit. Remember to upload yoursolution with tag #justknimeit-2 to your public space on the KNIME Hub. UploadfileConvert date 1Convert date 2Extractyear + monthFilename for groupsYear to stringExtractmonth dataPreparefile name 1Preparefile name 2Save csvfilesGet pathfor CSV writerLoop EndTidy up CSV Reader String to Date/Time(legacy) Legacy Date&Timeto Date&Time Extract Date&TimeFields String Manipulation Number To String Group Loop Start Table Rowto Variable String Manipulation(Variable) CSV Writer String to Path(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: Loeffler
Created at: 2022-02-03
On NodePit since: 2022-02-04
Last update: 2024-04-20
Created with KNIME version: v4.5.1
Tags: just knime itweek 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!