You can translate the question and the replies:

Excel Data Source: Is it possible to create a view on a directory containing the excel files?

Is it possible to create an excel data source based on a directory of files versus an individual file? If so, how would you configure this?
06-10-2017 13:48:43 -0400

3 Answers

Hi, In Virtual DataPort, by using FileSystem Custom Wrapper you could retrieve data from multiple excel files that have same structure. The FileSystem Custom Wrapper can be dowloaded from [Denodo Support Site]( I would do the following steps to create a datasource over excel files, * Create a custom datasource using the FileSystem Custom Wrapper. * Create a base view (bv_view1) over that Custom datasource and provide the value for parameters "recursive" and "parent folder". Refer the user manual in the directory <Denodo-filesystem-customwrapper_Home>/doc. * Create a new Excel data source, by choosing "Local" as file location and specify interpolation variable (@variablename) in the file path. * Create the base view (bv_view2) in the Excel data source. Refer the [Paths and Other Values with Interpolation Variables ]( section for more information on interpolation variable. * Create a join view between the "bv_view1" and "bv_view2" based on the condition, `bv_view1.fullpath=bv_view2.variablename` * Execute the join view to get the desired results. Hope this helps you!
Denodo Team
11-10-2017 09:09:14 -0400
Instead of local server how can i access the file thats not on the same server as the denodo server?
07-06-2021 10:18:47 -0400
Hi From Virtual DataPort server, in order to access the files in other server I would create symbolic link by following the steps provided in the Knowledge Base article [Accessing network drives from Denodo Virtual DataPort]( Hope this helps
Denodo Team
 Edited on: 22-06-2021 10:21:52 -0400
You must sign in to add an answer. If you do not have an account, you can register here