Denodo accepts file patterns with regular expressions when configuring a path to a file. This allows the Denodo Platform to find all files with a certain pattern in a directory and import them.
For example, when I want to access all the text files in a specified folder, I create a [Delimited File data source](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources) and do not add a specific file to the file path. Instead, I add “(.*)\.txt” to the “File name pattern” field; Denodo will combine the data from each text file into a base view. Denodo also offers the [DateRange function](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#paths-using-date-ranges) for files ending in dates. Each execution of the base view will query all the files in the folder and add or remove rows in the base view according to the data from the files in the folder.
Another method to select all files in the folder is to use the [Denodo FileSystem Custom Wrapper](https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20FileSystem%20CustomWrapper%20-%20User%20Manual). The wrapper returns a view with the information about files in a specified parent folder. I use this to create a join from the FileSystem base view to a Delimited File source with ‘@FULLFILEPATH’ variable in the “File path” field connected to the “fullpath” field in the Filesystem base view. This will search the folder for each file and then extract the data as a Delimited Source.
For more information, I’ve included links in the text to the Denodo User Manual for each of these topics.
I hope this helps!