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...

       

      Table:

      Load Sum(Sales)

      Dept

      MonthYr,

      Resident Production

      Group by Dept

      Where MonthYr = Jan2010;