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

How to search for a range of dates based on a text value - Interpolation variable
answered 24-09-2021 12:46:56 -0400

I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source. select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate = '09-01-2021' ...

Answers: 3

Interpolation Variables AWS S3

CustomWrappers and base view Interpolation variables
answered 16-03-2021 08:36:00 -0400

Hello, We are in the process of creating a custom data source for one of our internal sources. It takes two CustomWrapperInputParameters, both mandatory strings. public CustomWrapperInputParameter[] getInputParameters() { return new CustomWra...

Answers: 1

Interpolation Variables Custom Data Sources

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

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 Interpolation Variables Create Base View join

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

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