3 Replies Latest reply: Aug 3, 2014 1:36 AM by Neeraja Nagreddy RSS

    Use variable for fieldnames in loadscript

    Richard van den Braak

      Hi All,

       

      In my excel sheet if have columns with as name the year (2014,2013,2012, etc)

      In the load script i have a calculated field where i use last (2014) and the previous year (2013).

      Next year I need to use the columns 2015 and 2014.

       

      I want to create a variable vLastYear and vPrevYear so I can use these in stead of hard coded data. So I only have to change the content of the 2 variables vLastYear and vPrevYear.

       

       

      Load *,

           ....     

           If( ([2014] > [2013]) ,Chr(9660), Chr(9650) ) As Direction

           .....

      Resident TableName;

       

      Any suggestions ??

      Thanks.