Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
henryslk
Contributor
Contributor

how can I use a proc with parameters dynamically?

Hi, please I have a proc and it needs 2 parameters to return a result, I use this script to call this proc

LIB CONNECT TO 'Microsoft_SQL_Server_servidor';
[Data]:
SQL exec Prueba_1 @year = 2019, @var = 'A' 

But I need use this parameters dynamically, and choose the year since other consult, for example

[years]:
LOAD
[year];
SELECT year,
FROM BDData.dbo."years";

How can I make this?

Labels (1)
0 Replies