Q&A

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

Wrapper Missing 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

Iterate Api
answered 29-09-2020 21:09:37 -0400

Hello, I have 12 number of pages with my API with limit of 1000 and offset of 1000. Now If I obtain a single page of data it consists of 1000 rows of data and I cannot increase the limit to even 2000 becuase of source that provides only 1k data at a ...

Answers: 1

Pagination #API #Rest_API

Flatten view
answered 29-09-2020 16:27:53 -0400

Hi Team, I have created one view from Json data source.In this view there are multiple columns and 4-5 coloumns are itself a collection of array.And Inside these element array there are elements which are itself a collection of array. I want to flatt...

Answers: 1

JSON Data Source FLATTEN

Pagination related question
answered 29-09-2020 15:02:12 -0400

I am calling an external API to Denodo which is a JSOn. That API has set default 1000 records which I received as it is in denodo. I was unable to fectch more record in denodo with that API so I thought of Pagination in JSOn DS> configure > Pag...

Answers: 1

Perform a join and only keep the first row
answered 29-09-2020 08:09:21 -0400

Perform a join and only keep the first row when the join condition it met

Answers: 1

How to remove leading zero's in date time stamp
answered 29-09-2020 05:57:13 -0400

I have below string output using Formatdate function applied 08/03/2017 04:48:34 PM How to remove leading zeros O/p - 8/3/2017 4:46:34 PM Please help

Answers: 1

Date time function

Convert rows into columns after flattening in denodo
answered 29-09-2020 02:05:34 -0400

I have created a base view out of an API which returns me some array rcolumns. I then flattened these columns using flattening function in denodo. But I get multiple rows for a single account. My requirement is to convert these rows in corresponding co...

Answers: 1