topic Re: Loop through a store proc passing a paremeter in QlikView

Loop through a store proc passing a paremeter

vvvvvvizard — Sat, 16 Nov 2024 01:08:37 GMT

Good day

I need to loop through this passing 'December 2019' , 'January 2020' and 'February 2020' as parameters into the sql statement

Stats:

Load*;

SQL EXEC Report.Prior_Month_Substitution @FinancialPeriod = N'January 2020';

Can this be done in Qlik or only using SQL code .

vvvvvvizard — Tue, 03 Mar 2020 12:17:41 GMT

I just need to pass the last 3 months dates into the parameter

dgreenberg — Tue, 03 Mar 2020 18:50:19 GMT

I don't see why you can't do it with a for next loop in the load script.

Something along the lines of:

let myParm1='December 2019';
let myParm2='Januuary 2020';
let myParm3='February 2020';

for A=1 to 3
let mySQL='SQL EXEC Report.Prior_Month_Substitution @FinancialPeriod = N' & myparm&A;

Load *;
mySQL;
next A;