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