Q&A BY TAG 'Dynamic'
Dynamic Base View based on another Base view (not JOIN)
answered
04-01-2021 12:18:07 -0500
Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...
Answers:
5
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
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
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
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