I have create the following workflow and wanted to consolidate three files in a folder. [image] This is the result I want: [image] But the result the I’ve got it’s duplicated for three times. What did I do wrong? [image]

Hello @newba , Welcome to the community . If you have the same columns in all the excel files, you don’t need to use loop nodes anymore. You can use files in a folder option. [image] To select only the files that you want, you can use wildcard or regex filter in Filter options → File Name [image] If this doesn’t solve your issue, you can always use loop node I think it is better to use List files/folders node instead of Read Excel Sheet Names node as your requirement is about different files in a folder rather than different sheets in a excel file Please make you sure the variables you are creating are of path format. with loop end node configuration [image]

consolidate files in a folder

KNIME Analytics Platform

mlauber71 August 15, 2022, 12:44pm 3

@newba you could check if forcxing to use the Excel Sheet name thru an additional variable might help you (there is a ticket for a possible problem with that AP-18133)

1 Like