Q&A BY TAG 'Interpolation Variables'
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
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
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
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