title: Using variable values in LOAD * INLINE Statement
body: <p>I am trying to use variable values within a load inline statement but rather than the variable values being loaded im getting a weird substring of the variable formula.</p>
  
  <p>What i am doing wrong?</p>
  
  <p>So TEMPTABLE is loaded from a file, its shows monthly data, i need to show that data as daily data, so i divide the values by the number of days in that month and then want to load these into 'Final' table.</p>
  
  <pre><code>Set vNoOfRows = NoOfRows('TEMPTABLE');
  
  FOR i=0 to $(vNoOfRows)
    SET vYear=Peek('Year',$(i),'TEMPTABLE');
    SET vMonthName=Peek('MonthName',$(i),'TEMPTABLE');    
    SET vCOMPANYNAME=Peek('COMPANYNAME',$(i),'TEMPTABLE'); 
    SET vTYPE_BUSINESS=Peek('TYPE_BUSINESS',$(i),'TEMPTABLE'); 
    SET vSUB_PRODUCT=Peek('SUB_PRODUCT',$(i),'TEMPTABLE'); 
    SET vRENEWAL=Peek('RENEWAL',$(i),'TEMPTABLE'); 
    SET vDaysincurrentmonth=Peek('DaysInMonth',$(i),'TEMPTABLE');
    SET vDayCount=Peek('Daycount',$(i),'TEMPTABLE');  
    SET vPolicies_Day=Peek('Policies_Day',$(i),'TEMPTABLE');
    SET vUWP_Day=Peek('UWP_Day',$(i),'TEMPTABLE');
    SET vGWP_IPT_Day=Peek('GWP-IPT_Day',$(i),'TEMPTABLE');
    SET vClaims_Day=Peek('Claims_Day',$(i),'TEMPTABLE');
    SET vIncurred_Day=Peek('Incurred_Day',$(i),'TEMPTABLE');  
  
    Set a=1;
  
     Do while a&lt;=$(vDaysincurrentmonth)       
  
      FINAL:
      LOAD * INLINE [
              Year,MonthName,Day,COMPANYNAME,TYPE_BUSINESS,SUB_PRODUCT,RENEWAL,Policies_Day,UWP_Day,GWP_IPT_Day,Claims_Day,Incurred_Day
              =$(vYear),=$(vMonthName),=$(a),=$(vCOMPANYNAME),=$(vTYPE_BUSINESS),=$(vSUB_PRODUCT),=$(vRENEWAL),=$(vPolicies_Day),=$(vUWP_Day),=$(vGWP_IPT_Day),=$(vClaims_Day),=$(vIncurred_Day)     
       ];
  
      Let a=$(a)+1;
    Loop
  
  NEXT i
  DROP TABLE TEMPTABLE;
  </code></pre>