consolidate files in a folder

I have create the following workflow and wanted to consolidate three files in a folder.

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.

To select only the files that you want, you can use wildcard or regex filter in Filter options → File Name

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

2 Likes

@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

After I removed the loop. It works perfectly!
Thank you so much!

2 Likes

This is really helpful. Thanks!

1 Like

Thanks @newba , for confirming that my suggestion worked.

Please make my reply as the answer so that people can know which is the solution to your problem.

1 Like

Thanks for telling me that.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.