You can translate the question and the replies:

Date Range function does not work in path configuration

Based on this documentation: 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 ...
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]( and the knowledge base article [Using logcontroller and useful log categories]( 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