Want to load table within a loop

ferha_jafri — Mon, 03 Jun 2024 14:00:25 GMT

Hello Experts,

I have a requirement in which I want to load a table again and again for the loop.

let vStartYear = Year(Date(AddYears(Today(),-1),'YYYY-MM-DD'));

let vEndYear = Year(Date(AddYears(Today(),+1),'YYYY-MM-DD'));

NoConcatenate//Base to start
BasePop_Temp:
Load
Distinct
Com_Num_Base,
CompNumExist,
PlT_Base,
EffDt_Bae,
ExpDt_Base,
Prd_Line_Base,
'Base' as Flag_Base,
Com_Num_Base&'-'&month(EffDt_Bae)&'-'&Prd_Line_Base as RenKey

Resident Table1 Where Year(Prd_Line_Base) = '$(vStartYear)';

NoConcatenate
BasePop: //next year
Load
Distinct

Com_Num_Base,
CompNumExist,
PlT_Base,
EffDt_Bae,
ExpDt_Base,
Prd_Line_Base,
'Ren' as Flag_Base,
Com_Num_Base&'-'&Prd_Line_Base as EnhaceKey

Resident Table1 Where Year(EffDt_Bae) = '$(vStartYear)'+1 and Exists(RenKey,Com_Num_Base&'-'&Prd_Line_Base);

I want to load BasePop, which loads for each year to concatenate one after the other for each year.

Thanks in advance

Ferha

Re: Want to load table within a loop

marcus_sommer — Tue, 04 Jun 2024 12:25:56 GMT

Something like:

for i = $(vStartYear) to $(vEndYear)
// defining n variables to consider different fields/expressions/conditions in the iterations
YourTable: load ... resident ...;
next

topic Want to load table within a loop in Qlik Automate

Want to load table within a loop

Re: Want to load table within a loop