Q&A BY TAG 'ARRAY'

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

Check if Value in Array
answered 10-05-2022 08:27:46 -0400

Hi, I have to check if a string is a substring of a longer one. Trivially this would lead to INSTR which doesn't work in this particular case as some of the strings to look for are substrings of others (eg. 'abc', 'abcde', ...). The long string is deli...

Answers: 1

Array

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

How to avoid array data conversion into text format while creating base view?
answered 12-11-2021 07:47:31 -0500

I have created a data source connection with another denodo data base. That data base has view in which data are present in array form. On creating a base view from that view, the array data get converted into text form automatically. Could you tell me...

Answers: 1

Base view ARRAY Create Base View

Pivot rows into columns in an array
answered 01-10-2021 02:09:00 -0400

Hello, what I would like to achieve could be straightforward but I'm very new to Denodo. I have a view like this: model_id equipment 1 Array where the Array is like this: description v...

Answers: 3

Denodo 7.0 ARRAY Pivot

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

select query flatten ARRAY missing records JSON join

Interpolation Array
answered 06-07-2021 02:21:39 -0400

Hello, Is there a way to have an interpolation variable that will accept an array? Thank you.

Answers: 1

Array

Aggregation of derived views delegating search methods to base view
answered 02-04-2021 07:46:17 -0400

Hello, i have following problem. I want to expose a REST Web Service that shows aggregated data coming from one single Base View. The Base View can be seen as the following having some input parameters (BV has search methods): ID Desc...

Answers: 3

VQL Denodo 7.0 REST Base view ARRAY derived view data aggregation

Struggling with using a field with JSON data and tying it back to the original view using an ID field
answered 10-03-2021 01:32:44 -0500

I have a view that has a field called "primaryqa". it contains data that has answers to questions in JSON format that I want to parse and then joing back to the original view using an field called "id". [{"QuestionID":1,"Answer":"Yes"},{"QuestionID":2...

Answers: 1

joining of interpolation variables Interpolation Variables array

How to select distinct elements of an array column in a view
answered 04-03-2021 04:55:15 -0500

I need to select distinct values from few array columns in a view. My view consists few Array columns and I cannot group by them. SELECT * from {view} where {parameter} = '03645' Parameter Column 2 Column 3 Column 4 ...

Answers: 3

Distinct ARRAY #array #customfunction

Compound data type error
answered 20-08-2020 01:55:38 -0400

I am trying to create an array data type, I tried the following syntax shared in the below link https://community.denodo.com/docs/html/browse/7.0/vdp/vql/defining_other_elements_of_the_catalog/defining_a_data_type/defining_a_data_type#defining-a-data-...

Answers: 3

ARRAY Compound Types