Q&A BY TAG 'Interpolation Variables'
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
Delimited File sources with DateRange
answered
02-11-2020 03:49:16 -0500
Could someone provide an example which works for using Delimited Files with a date range in the file name (or path)? I have given up our own design for now, and I am currently trying to recreate the example from "Virtual DataPort Administration Guide"...
Answers:
10
1. How one can acess Encrypted Excel file via Excel data source.? 2. using an Interpolation variable will excel file who have all different password set
answered
17-09-2020 07:49:11 -0400
I have set passowrd to Excel file and was trying to access my file but it doent helped using Decrypt(DES, MD5 ) option How can we use interpolation variable when we have lots of locked Excel file. SO I have query around password only and How ca...
Answers:
1
Optional interpolation variables
answered
17-06-2020 08:14:12 -0400
Each time I create a base view over a JSON data source with interpolation variables, denodo asks me to provide all of the variables. But what if the API does not support the combination of all the variables together? E.g. there is external_id and local...
Answers:
3
Converting timestampz to epoch time
answered
06-02-2020 07:43:50 -0500
Hi, I have seen previous enquiries about a function to convert to and from epoch time before. Are there any possibility that this function will be prioritized in future patches? The autogenerated column "expirationDate" uses epoch time for the expirat...
Answers:
1
Denodo interpolation/parameter issue while using IN clause
answered
04-02-2020 07:07:55 -0500
Hi, I am facing an issue where using an interpolation variable in where condition of a dervied view. The views is something like this: CREATE OR REPLACE VIEW V1 AS SELECT Col1, Param1 FROM T1 WHERE Col2 = Param1 USING PARAMETERS (Param1 : text '12...
Answers:
1
Create BV with variable
answered
14-11-2019 06:04:52 -0500
Hello: I want to create a BV from a JDBC resource, and I have a csv, with some fields and I want to get the value of the variable from this CSV. the query is select name, address from people where country=@country and I have this CSV: L...
Answers:
1
how to use a interpolation variable in where condition of a derived view
answered
14-11-2019 04:46:49 -0500
Hi, I want to to pass a dynamic value as filter in where condition. I am try column1 =@input_value_for_column1 can you suggeset as why its not working, do we need to do anythign else to use interpolation variable or to pass the value dynamic in the w...
Answers:
3
Credentials in message body?
answered
23-09-2019 01:03:34 -0400
I have two web service data source which expect the user name and password to be passed as part of the POST body. This is easy to make work with interpolation variables but is far less than ideal. Is there a method where the configured credentials c...
Answers:
5
Interpolation of function and variable.
answered
26-09-2018 08:27:23 -0400
I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...
Answers:
1