Q&A BY TAG '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 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
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
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
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
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
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
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
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