# Data blanding by reading several files in several folders by iterating excel column **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [November 24, 2022, 9:57pm UTC](https://forum.knime.com/t/data-blanding-by-reading-several-files-in-several-folders-by-iterating-excel-column/49352 "2022-11-24T21:57:28Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\ **Post date:** [November 28, 2022, 6:08pm UTC](https://forum.knime.com/t/data-blanding-by-reading-several-files-in-several-folders-by-iterating-excel-column/49352/5 "2022-11-28T18:08:02Z")
@abekchanov yes I got them. Thank you for the samples. I put together an example that you could check out. What I noticed is that your example is not consistent the file\_3 and file\_2 are not meant to be in folder\_3 - so I inserted a Try/catch block to deal with the error. > **[KNIME forum question (49352) - loop thru file steered by a meta file and...](https://hub.knime.com/mlauber71/spaces/Forum/2022/kn_forum_49352_collect_files_paths_subfolders~z840Qefa8dG4EVQ0/current-state)** > > KNIME forum question (49352) - loop thru file steered by a meta file and extract certain rows Also you might want to check how to construct file variables > [@Write multiple CSV file to a loop](https://forum.knime.com/t/write-multiple-csv-file-to-a-loop/44989/2): > > @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](https://kni.me/n/q7loejCZ1HWH5hUr) node. [image] --- _[View the full topic](https://forum.knime.com/t/data-blanding-by-reading-several-files-in-several-folders-by-iterating-excel-column/49352)._