Q&A BY TAG 'Excel'

You must sign in to ask a question. If you do not have an account, you can register here

Denodo 8.0 Update 8.0u20220815
answered 02-09-2022 15:00:36 -0400

We have upgraded to Denodo 8.0 Update 8.0u20220815 Wed design studio we could see "S3" listing under Data Route option while I am trying to add datasource as "excel" But the same is not listing on Virtual Dataport Administration Tool Thanks

Answers: 1

S3 Excel excel data source

Automation of Metadata
answered 03-08-2022 19:30:00 -0400

Hi Is there a script that automates the reading of metadata into denodo VDP and not the catalog since all the data sources are from excel? Like the data type and the field description without having to copy and paste from the excel metadata file?

Answers: 3

Excel Metadata

excel data source
answered 20-06-2022 07:52:05 -0400

Is there any way to create a excel data source of the file stored in the local system of the user not in the local system of virtual dataport server? or is there any way to move the file from local system to local system of virtual dataport server?

Answers: 1

Excel DataSource

Excel text field is defined as double in base view
answered 22-04-2022 09:20:44 -0400

I am using Denodo 8.0. I have an Excel spreadsheet data source which contains multiple worksheets. I have created the data source for each worksheet. All of the data columns are defined as General or Text on the Excel spreadsheet. But when I create the...

Answers: 5

Excel

Join Views with fields that have similar data, but not identical
answered 29-12-2021 05:25:21 -0500

Hello, I'm new to the Deonodo coummunity. I'm currently working on a poc using two Exel datasources I've created and built views on top of. I am trying to join two of these views together based on a field that contains a calendar quarter. In one field ...

Answers: 1

Excel join

Cube data present in excel
answered 25-11-2021 02:18:59 -0500

Hi , i have aan excel as a source file which would be uaed in Denodo.The data is a cube. please help to find a way out to load the data in Denodo through this file. Thanks & regards, sajeda

Answers: 1

Excel

To create Excel Datasource from Sharepoint using Authorization grant as client credentials
answered 17-11-2021 16:25:29 -0500

Hello Team, When we try to create a Excel datasource from Sharepoint using OAuth2.0 with Authorization grant as Authorization code we are able to generate the code and create the datasource but it is not feasible process as we have to open the Authori...

Answers: 1

Excel SharePoint

Import file excel into bv
answered 17-11-2021 01:04:54 -0500

Hello I have a file excel present on the same machine where denodo is installed. I need to import it to be able to query it via denodo. I tried to create a new excel datasource via FTP / SFTP / FTPS Path but I don't risk it as it doesn't recognize the ...

Answers: 2

Import Excel sftp

Excel Data Source: Is it possible to create a view on a directory containing the excel files?
answered 22-06-2021 10:21:15 -0400

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?

Answers: 3

Excel Data Source Mulitple Files

Connecting to a remote Excel file using Denodo Express
answered 10-06-2021 17:05:37 -0400

Hi, I need some help trying to connect to a remote Excel file as a data source. I have two servers (A & B), server A has Denodo Express installed on it, how, do I go about connecting to a Excel file on Server B? Using the FTP or HTTP options does...

Answers: 6

Excel Denodo Express