[beginner] folder creation with loop

I am trying to create a small project to learn Knime.
I have a file (actually multiple files) with a column for departments and other columns.
My goal is to split this file into many smaller files sorted by department, in JSON or CSV format, saved in directories named after each department number.
I made a simple workflow for this.

2 problems, loop don’t work, and I don’t know how to name folder and file in the same time. I try this (I follow this example https://hub.knime.com/s/anrDBtBILq9bbMzy)

thank a lot

Can you share your workflow? Without knowing the exact structure of the input its difficult to offer any clear advice. Make sure the data is stored with the workflow.

@al_pasq most likely you will have to edit a part of the path before applying it to the File/Folder Creating variable

2 Likes

Hi,

you don’t have to create the folders seperatly. The CSV writer holds the option to create folders if they are missing.


Here’s the Workflow

1 Like