Q&A BY TAG 'Interpolation Variables'

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

Delimited File sources with DateRange
answered 19-10-2020 19:10:18 -0400

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: 9

Interpolation Variables Delimited Files

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

Excel Interpolation Variables Denodo Excel Add-In

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

Base view Interpolation Variables Create Base View

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

Interpolation Variables Epoch time timestamp

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

Interpolation Variables param default value IN cl

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

Base view Interpolation Variables variable

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

Interpolation Variables

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 Variables Password

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

Function oracle Interpolation Variables

Interpolation variable - Passing value from another base view
answered 24-08-2018 02:57:02 -0400

I have first base view with interpolation variables. I would like to pass values for them from second base view. To achieve this, I have created a derived view joining first and second base views. it is working fine until there is a null value in one o...

Answers: 1

Interpolation Variables