all the Excel files that are in the same pattern from the same folder and put them in another folder.

[liazi]

Hello,
I need your help.
I want to get all the Excel files that are in the same pattern from the same folder and run the filters I made and put them in another folder.

How can I do this? I tried List Files/Folder but I didn’t know how to do the Loop.
And I tried Table Row to variable, but it doesn’t save the files in XLSX format.

[mlauber71]

@liazi you would:

• list the files you want (pattern .xlsx or part of name) (Work with File Names and Moving Files. – KNIME Community Hub)
• extract the file name from the path (add a suffix to a file and copy it to a new subfolder – KNIME Community Hub)
• construct a new name and path (Write multiple CSV file to a loop - #2 by mlauber71)
• copy/move the files to the new location / folder (add a suffix to a file and copy it to a new subfolder – KNIME Community Hub)

In your example you are loading the data into KNIME which of course you can do. Question is do you need that or would you just copy/rename/move the files

https://docs.knime.com/latest/analytics_platform_flow_control_guide/#introduction