I have a column which has three unique values A, B, C. I want to write three different excel files in a local folder directory corresponding to each of these groups A, B and C. Is there a way to use the group loop start node and somehow pass variable file name to the excel writer node and create 3 files (in 3 loops). I could not find a way to pass variable file paths to excel writer node. Any help would be deeply appreciated. Thanks.

@sidharth_1993 you can take a look about how to create path variables in KNIME: [image] Write multiple CSV file to a loop KNIME Analytics Platform @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]

How to use group loop start node along with Excel writer to write files for each group

KNIME Analytics Platform

mlauber71 January 24, 2023, 9:36am 3

@sidharth_1993 you can take a look about how to create path variables in KNIME:

2 Likes