Q&A BY TAG 'ARRAY'

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

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 Base view REST ARRAY derived view data aggregation

Pivot rows into columns in an array
answered 01-04-2021 08:07:04 -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: 1

Denodo 7.0 ARRAY Pivot

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

Interpolation Variables joining of 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

ARRAY Distinct #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

JSON Data Source Array Issue
answered 17-07-2020 11:25:32 -0400

Hi, I am trying to create a Base View for a JSON based Data Source : [{"a":1, "b":2, "c":3}, {"a":11, "b":22, "c":33}, {"a":111, "b":222, "c":333}, {"a":1111, "b":2222, "c":3333}, {"a":11111, "b":22222, "c":33333}] If I create the view using the defau...

Answers: 2

data array JSON

Denodo alternative for TSQL "STUFF.... FOR XML PATH"
answered 04-10-2019 02:35:33 -0400

Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a com...

Answers: 2

ARRAY

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

nest function fails when field contains null as values
answered 21-09-2015 12:34:22 -0400

Hi, I Have a problem while returning an array over a set of fileds where some of them might contain null (This is a valid value) inside a stored procedure In the stored procedure i have the return value as below new StoredProcedureParameter( "ord...

Answers: 1

ARRAY Stored Procedures

String Processing to array to last item in 1 swoop
answered 30-06-2015 01:35:20 -0400

I have a data source with multiple columns being a uri. I need to process it to get the last "item". We can simply create one for the sake of this question & try it out using the VQL shell. select split('/', 'http://server:9090/denodo-restfulws/tutori...

Answers: 2

VQL ARRAY