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:
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: