You can translate the question and the replies:

Date Range function does not work in path configuration

Based on this documentation: https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources When I try to put this in the file path of the data source: C:\Users\goaa\Temp\T^DateRange("yyyy/MM/dd","2020/01/01","2020/03/31","yyyy-MM-dd").txt I cannot reach the created file T2020-01-11.txt created in the corresponding folder. Unable to establish connection: C:/Users/goaa/Temp/T2020 ...
user
29-01-2020 10:41:23 -0500

1 Answer

Hi, I've been able to create a base view from a set of files using the DateRange function with your exact same patterns. I just make sure to typedit on the '*File Path*' field of the configuration of the Data Route and not on the '*File name patter*' field. Sometimes when a file in the range defined is missing I get an error but the rest of the files are accessed and their rows retrieved properly. What I would do to identify your problem if I was in your situation would be to make sure that the user running Denodo has all the apropriate privileges to open that file. I would also check the vdp.log under <DENODO_HOME>/logs/vdp/ to check for more information. I usually make use of the stored procedure [LOGCONTROLLER](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/logcontroller) and the knowledge base article [Using logcontroller and useful log categories](https://community.denodo.com/kb/view/document/Using%20logcontroller%20and%20useful%20log%20categories?category=Operation) to help me with this task. Hope this helps!
Denodo Team
31-01-2020 19:04:14 -0500
You must sign in to add an answer. If you do not have an account, you can register here