Q&A

Select Distinct records based on a particular value in another column
answered 06-10-2020 08:23:23 -0400

I have a result of employees with "employee id" that has duplicates. I have another column called "leader level" i want to keep unique records of the employee id that has the lowest value of leader level (i.e. if the same employee id is in row 1 and 2 ...

Answers: 1

Distinct order by

How can I execute VQL in a text file on Job Sucheduler?
answered 05-10-2020 08:41:08 -0400

I want to execute DML that changes from time to time for a view. Is it possible to place the created a text file(VQL) on the Server and execute it on the scheduler?

Answers: 1

Exception parsing near query 'CREATE'
answered 05-10-2020 08:34:32 -0400

While I am creating the remote table for the ms sql server 2016, I copies the vql query of my dataset and paste in the VQL Query space in remote table option, but it is showing error . I am using Denodo 7.0 express version. Kindly get me through it as ...

Answers: 3

Syntax error

Different Denodo versions
answered 05-10-2020 08:31:44 -0400

Hi, Is it possible to have different versions of Denodo (e.g. version 7 & version 8) running on the same machine? They don't have to be running simultaneously. With kind regards, Phil

Answers: 2

Denodo Installation

Want API as paginated
answered 02-10-2020 08:30:49 -0400

Hello, Below is the Scenario, Please suggest I have extrenal API that gives me limit of 1000 records at a time. The data that I receive contains link for next page(a half link ex:) Full link is like : https:/exmaple.com/sgvu/myapi/query?Select n...

Answers: 1

Pagination #API #Rest_API

Error while building the denodo image with the a dockerfile provided in the website
answered 01-10-2020 08:31:24 -0400

I used the first Dockerfile provided at https://community.denodo.com/kb/view/document/How%20to%20create%20your%20own%20Docker%20images%20for%20Denodo%20Platform%20Containers?category=Operation to build the image, but I am get the following error : Ste...

Answers: 1

Perform a join and only keep the first row when the join condition is met
answered 01-10-2020 08:13:03 -0400

Thanks, for the fast response :) My original question: Perform a join and only keep the first row when the join condition is met Answer: I would add the clause LIMIT in the query which performs join to obtain only one row of the result set. For insta...

Answers: 1

Able to Connect to a SharePoint list but all Multi-select fields are missing
answered 01-10-2020 08:05:36 -0400

I am able to connect with OAuth2 to our Sharepoint site and pull down various lists, without issues. However, I have noticed that any fields that are "multi-select" are missing from the schema. Is there a setting I need to change to get this to work?

Answers: 2
Related to: Microsoft SharePoint as data source

Missing Wrapper SharePoint

How to remove leading zero's in date time stamp - 08/03/2020 04:05:15 PM
answered 30-09-2020 04:32:47 -0400

Hi Team\ I have format date 08/03/2020 04:05:15 PM want to remove the leading zero only on the date given above . How to do that.. Please help, its very urgent to implement on the job design. 08/03/2020 04:05:15 PM o/p 8/3/2020 04:05:15 PM

Answers: 1

Date time stamp

Denodo Scheduler: Is it possible to query the denodo scheduler and get a list of jobs, schedules, etc?
answered 30-09-2020 01:07:58 -0400

Is it possible to query the denodo scheduler data? IE: Can we get a list of projects, jobs, and their triggers?

Answers: 1

Denodo 7.0 Scheduler Query Scheduler