Challenge 2 - Split File and Save Into Subfolders - Solution

0 ×

Challenge 2 - Split File and Save Into Subfolders

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 and subfolders in the workflow data folder.

Dataset: https://kni.me/s/vrlYVaryZtBlyTsB

Nodes

• CSV Reader1 ×
• CSV Writer1 ×
• Column Filter1 ×
• Create File/Folder Variables1 ×
• Extract Date&Time Fields1 ×
• Show all 11 nodes

Extensions

• FeatureKNIME Base nodes

Links

• No links available