4 Replies Latest reply: Nov 9, 2013 11:12 AM by Steve Zagzebski RSS

    Looping Script with Variables

    Steve Zagzebski

      I need to write a script that creates a table for every month using variables:


      Basically what I need is to run the following script for every month through Oct2013. (40+ times!). Each table would be concatentated with the previous (so would have one big table at end). How can this be done so I loop through each month? I am trying to avoid writing this code 40 different times...



      Load Sum(Sales)



      Resident Production

      Group by Dept

      Where MonthYr = Jan2010;