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 use interpolation variables in base view?
answered 29-11-2022 20:55:19 -0500

i want to use input prameter field in base view. Can someone tell proper method .

Answers: 1

Interpolation Variables

Interpolation Variable - Date function
answered 09-11-2022 13:21:04 -0500

Hi, I am trying to create a base view with query from DB2 in which I included 2 parameters Begin_date, End_date that are added in where clause to filter Date(confirm_date) column. Example: Select * from Table where Date_column between @Begin_date and ...

Answers: 2

Date Conversion Interpolation Variables DB2

Interpolation Variable using a formula - Julian calendar date
answered 06-04-2022 09:07:18 -0400

I have a data source which requres a dynanmic file name to be reference using a Julian date - last two digits of the year and the current day number. So 2022-04-04 would be 22094. Is there an easy way to include this value as part of the interpolatio...

Answers: 1

Formula Interpolation Variables Date time function

Interpolation Variable with Power BI
answered 20-12-2021 04:22:23 -0500

I have created final view with interpolation variable. I would like to use this final view in power BI. I need to pass value to the interpolation variable from power bi report and load only the particular dataset to the model. How can I achieve this

Answers: 1

Interpolation Variables Power BI

How to search for a range of dates based on a text value - Interpolation variable
answered 04-10-2021 11:47: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: 6

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