Problem with loop function causing end of memory

[RSQlik]

Hello everyone

I have a problem , I am working on payroll project , trying to give for each heading label the associated salary amount for it , based on 2 fields : salary_amount and heading_label

for exemple : if i have the heading label : bonuses , the salary amount became salary_amount_bonuses with the correct value of salary amount.

i programmed a code that gives the wanted result but only on small data but with the various of heading label values it caused a less of memory error

can any one help me to correct this code :

FOR Each Model2 in FieldValueList('heading_label')
LET vDOUBLE2= keepchar(Replace(text(Model2),' ','_'),'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWZYZ0123456789_');
Join
load
Payroll_Id,
heading_label,
Regroupement,
if(heading_label='$(vDOUBLE2)',Salary_Amount) as Salary_Amount_$(vDOUBLE2)
resident Payroll ;
Next Model2

[Sue_Macaluso]

@RSQlik  I noticed that this hasn't been responded to. I wanted to confirm what product you are using in case it's in the wrong forum and once I know I can ping someone or move it to the correct place. Thanks.