Icon

KNIMEit_​2

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.

Node 1Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16Node 17Node 18Node 19CSV Reader Group Loop Start String to Date&Time Extract Date&TimeFields Number To String Table Rowto Variable String to Path(Variable) Create File/FolderVariables CSV Writer Variable Loop End Column Filter String Manipulation(Variable) Node 1Node 9Node 10Node 11Node 12Node 13Node 14Node 15Node 16Node 17Node 18Node 19CSV Reader Group Loop Start String to Date&Time Extract Date&TimeFields Number To String Table Rowto Variable String to Path(Variable) Create File/FolderVariables CSV Writer Variable Loop End Column Filter String Manipulation(Variable)

Nodes

Extensions

Links