You can translate the question and the replies:

Passing fields as parameter

Hi Team, I would like to know how can I parameterized values on denodo quiries. e.g Whenever I execute a query a pop up must apear asking me to type in dates.
08-09-2021 04:20:17 -0400

1 Answer

Hi, In order to pass the values dynamically, I would use the [interpolation variable]( By using interpolation variables, paths and other parameters of data sources can be parameterized. Hence, I can provide the values of a field at runtime instead of design time. For example, if I need to create a base view that allows us to pass the value for a field at runtime, I would perform the following steps: * Create a base view by using the ‘[Create from Query](’ option. * Write the query and replace the input parameters with interpolation variables like @VARIABLE. * Click OK and enter the values of the variables(any possible sample values) used in the query. You can refer to the similar community Question[ How to create base view which accepts parameter]( for more information. Hope this helps!
Denodo Team
08-09-2021 06:56:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here