Q&A BY TAG 'Dynamic'

Dynamic column names generated from a pivot
answered 24-04-2020 02:20:09 -0400

Is there a way in Denodo to do a pivot where you generate the column names from a column's distinct values. The only example I could find for Denodo used static values you already knew. I am assuming if there is, it is going to have to be custom VQL q...

Answers: 4

Dynamic Pivot

Denodo Inserts with dynamic values
answered 20-02-2020 07:25:32 -0500

Is it possible to insert records in denodo base views with the below query insert into base_view1 (col1,col2) select col1,col2 from base_view2; With the current doc I concur we can only insert hard coded values like below insert into base_view1 (col...

Answers: 1

Dynamic Insert Operation

Executing Dynamic VQL generated from view output
answered 20-11-2019 18:54:48 -0500

Hi, We have a list of report views that are cached for which we need to generate the report which shows the count or records for all those views. There is a view we have which could give the names of these views that we have to get the counts on. Is ...

Answers: 1

Dynamic

Using an interpolate variable in FROM clause
answered 05-04-2017 08:23:19 -0400

Hi team, I am trying to create a base view from a query based on an interpolate variable within the FROM clause. (SELECT * FROM {schema}.@TABLENAME). I want to do this because the platform I am trying to reach (OutSystems) uses a database with 2 layer...

Answers: 1

Dynamic Interpolation Variables joining of interpolation variables OutSystems