Creating Folders and writing files

[iperez]

I need to process a file in which there is a string column, for each of the values of that column I must create a directory and a file with the rows to which that value corresponds, for example for the category “CO Investment” one should get the following :
host/CO Investment / CO Investment.xlsx.
Inspired by the flow (Create multiple folders – KNIME Hub) contributed by @Kathrin I created the following flow:

Folder file creation.knwf (2.4 MB)

I have two issues:
1.- Why the file corresponding to the first value of the Group Loop node is being written?
2.- The workflow looks over complicated, is there a simpler way to do it?

[elsamuel]

To answer your questions:

1 - You haven’t closed the loop. In this configuration you’d need to connect a Variable Loop End to the Excel Writer node.
2 - This workflow is is quite complicated:

The way you’ve implemented the folder creation process isn’t as efficient as it could be. Also, it seems to me that you’re going in circles creating variables from data then converting them to data then back to variables then back to data and then back to variables.

Here’s a workflow that does what I think you want, with fewer nodes:

Folder file creation – elsamuel

[mlauber71]

@iperez here I tried to illustrate how the path generation does work.

Write multiple CSV file to a loop

@VJAM the creation of Flow Variables for Paths is maybe not 100% straightforward. Maybe this example might help to sort it out. The “path_values” is maybe not perfectly named. I think this is constructed that you could pass several Folder variables as collection strings. Also: CHunk Loop Start might have to be set to 1. Often I prefer the Table Row to Variable Loop Start node. [image] [image]

Also most writers allow the option to create missing folders, although I like the option to only create new folders deliberately.