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:

      table.bmp

       

      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?