Import files from subfolders

1

Hi,
I have multiple files saved in subfolders inside a given folder.
Is it possible to import all the files without iterations?

2

Hi @michel.baldellon ,

welcome in this community, about your question: I suppose that you are using the “Import something file” action (like “Import Excel spreadsheet”), the only way that I know to achieve what you are asking is to have an iteration.

Iterated module:

In a new module of the project add a parameter “parmPath”

Add an action “Import Excel spreadsheet”, from the dropdown option choose “Parameter” and then choose the param. Remember to flag this table as default.

image
image473Ă—235 7.23 KB

Main module:

add “list of files” action with “scan subfolders” option enabled. Filter the results so that you have the list of files you need. After that use the “Iterate” action on the iterated module, passing as a parameter the path of the file.

I hope this could help!

1 Like
3

Hi Michel and Andrea,

All the "Import" action that import local files have a "Load list of files" mode where you can specify a list of files to import as a column in the input dataset:

image
image1173Ă—1003 69.8 KB

1 Like
4

Thank you Andrea :folded_hands:

5

Thanks Andrew. A “scan subfolders” option would be fine…