Q&A BY TAG 'FLATTEN'

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

JSON datasource - HTTP POST - ARRAY request and response FLATTEN
answered 21-03-2022 04:15:04 -0400

HI, i've set a JSON source for the API https://www.openfigi.com/api, with a parameter in POST body. CREATE DATASOURCE JSON ds_openfigi FOLDER = '/01-connectivity/01-data-sources/openfigi' ROUTE HTTP 'http.CommonsHttpClientConnection,120000' POST 'http...

Answers: 1

ARRAY JSON FLATTEN JSON Datasource

Json array in data set - joining back to original data --- losing records when select * is used
answered 11-08-2021 06:58:14 -0400

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

Answers: 2

flatten select query ARRAY missing records JSON join

Flatten multiple view in one go
answered 06-05-2021 13:56:52 -0400

Hi, when I am trying to flatten many arrays in one go but I coudnt, can you please let me know how can I do it. I read some community questuon where you said it cant be possible. **If there is valid support contract can one get it done?

Answers: 1

FLATTEN

Convert CSV into rows without the use of SPLIT function
answered 07-01-2021 02:08:55 -0500

Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.

Answers: 1

Delegate FLATTEN Split

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

Working with JSON hierarchical data
answered 21-07-2020 15:24:12 -0400

Hi Denodo Team, I am struggling with virtualizing data which is in JSON format (and can only be pulled in JSON format from the API). There are numerous arrays within Registers within arrays. My requirement is that I do not create numerous flattened vi...

Answers: 3

flatten JSON

How to flatten JSON Source on web returning different number of registers based on parameters
answered 12-05-2020 16:05:41 -0400

Apologies if my query has been answered elsewhere, but I haven't been able to find a relevant article / direction so far. I have an API source that is drawn into VDP as a JSON format. The API accepts dates as input parameters. Based on the dates enter...

Answers: 2

flatten registers Json date parameters

Flatten query parameters (array of string)
answered 15-04-2019 10:47:14 -0400

Hello, I have a table with an ID of a company and WS for getting an information if the company can be trusted or not. The problem is with the WS. In default, it has parametrized input array of string and returns two arrays of outputs. I used FLATTEN fu...

Answers: 3

flatten ws

Adding field in flatten view with file name as value
answered 05-06-2018 05:41:41 -0400

I am creating a flatten view on top of the base view of JSON Data Source. I want a new field to be added in the output within which the field contains file name( ex:- name.json) as value.

Answers: 1

flatten field json JSON FLATTEN

How to flatten an unknown hierarchy
answered 22-01-2018 12:52:33 -0500

I have a JSON datasource which returns a hierarchy along the lines of the JSON below. The key thing here is that from one web service call to the next the folder structure can differ i.e. each folder is an array and can contain different numbers of sub...

Answers: 1

flatten array JSON