I created a workflow that demonstrates how such a job could be done. I use two loops. The first one lists all the folders from the import folder, the second one iterates thru all the CSV files found there.
The names of the folders and files are extracted and used to name the resulting Excel files. Maybe you could modify that to your needs.
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.6.0
Legal
By using or downloading the workflow, you agree to our terms and conditions.