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

[sidharth_1993]

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.

[ArjenEX]

Hi @sidharth_1993

Welcome to the KNIME community! Have a look around on the forum and the hub, there are quite a few examples available that cover this problem.

Write Excel with multiple sheets based on Group name – elsamuel

Controlling the output loacetion in a loop (new file handling) – kathrin

JKI_016_Grouping_Data_into_CSV_Files – knimest

[mlauber71]

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

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]

[sidharth_1993]

@mlauber71 , @ArjenEX , thanks a lot for the examples. I replicated this on my end and was able to solve the problem. Thank you!