Q&A BY TAG 'Excel'

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

how to use excel microsoft query to do some aggregation function on one denodo views?
answered 25-11-2019 13:10:19 -0500

I have configured 32-bit ODBC, and let my excel connect denodo views. I can pull the data from denodo to excel in detail level, how do I use microsoft query to do some aggregation caculation on some view. For example, denodo view_a (contain column mont...

Answers: 3


Microsoft Query (Excel) not Compatible to Denodo Query
answered 05-11-2019 12:41:13 -0500

Hi team, I used excel to connect denodo for views data visualization, I follow this link: https://community.denodo.com/tutorials/browse/basics/4connect2odbcclient . And it works. However, when I want to do some advanced query, not only get the detail...

Answers: 3

double quote Excel single quote Microsoft Query

HTTP client
answered 24-04-2019 13:38:18 -0400

Hi Team, Denodo Express 7.0 Please provide a working URL and supporting data for a MS Excel HTTP client example to practice. Thanks.

Answers: 3

Excel HTTP client

Start and End Cell Behavior in DenExp 7.0
answered 14-12-2018 07:28:48 -0500

Hi Team, Denodo 7.0 Express MS Excel 2010 Format .xlsx Id Name Age City 1 ABC London 2 PQR 20 Sydney 3 LMN 30 Munich 4 XYZ 40 Paris If I chose Start Cell as B1 and End Cell as D4. I get below result: Name Age ABCPQR 20LMN 30 XYZ 40 Why is city colu...

Answers: 1


source file info
answered 07-08-2018 15:14:16 -0400

Hi, I found some interesting predefined stored procedures here, but as far as I've seen, they don't deliver output I'm looking for: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_sto...

Answers: 3

Excel XML Delimited Files

Unable to import XML file .
answered 30-11-2017 07:29:36 -0500

We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...

Answers: 1

Excel XML CSV XML Data Source JSON

Excel Data Source: Is it possible to create a view on a directory containing the excel files?
answered 11-10-2017 09:09:14 -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: 1

Excel Data Source Mulitple Files

Data Lineage Report in Excel
answered 15-09-2017 08:25:38 -0400

I have created and SOAP Service using through multi step approch creating multiple derived views from Database base views. However, I would like to capture all the linege(all intermediate steps) and Base View to Service View mappings in a spreadsheet. ...

Answers: 1

Excel Lineage

Access Live SOAP WSDL Web Service through Excel
answered 28-07-2017 09:51:02 -0400

Hi, I want to access data from a SOAP Web Service (WSDL) through Excel. I want the process to be standalone/independent from Denodo. By this I mean, even when Denodo Platform is not running behind the scenes, once the excel is loaded with the data so...

Answers: 2

Excel automate SOAP Web Service WSDL

Export the Field Name and the Field Type of a base view to an Excel File or a Delimited file
answered 16-02-2017 05:00:45 -0500

I would like to export the Metadata information for a View (the Field Name and the Field Type) to an Excel file. Please let me know how I can do so. I am using version 6.0

Answers: 1

Excel export