4 Replies Latest reply: Feb 3, 2015 2:12 PM by Sunny Talwar RSS

    Select precise data

      Hi everyone, I need help to add one column in my script but I dont know how to do it.


      Desired table/information:



      I run the Loads and I want to add more information in this case the "Desired Column" aka Previous Points. This value corresponds to the last points from the Players.


      I am doing something like this:


      LOAD Points as PreviousPoints

      Resident Data

      // Where Day = Max(Date(Day)-1) and Player = ??


      I have to work on the clause where. Do you have any suggestion how it should be like to put another column like the example?