5 Replies Latest reply: Jul 24, 2015 10:23 AM by kushal chawda RSS

    Group Table

    Phil Speight



      I have a script which loads from different 4 different data sources.  All of them are for data based on a weekly interval.


      I also have some data which I want to load that is at daily interval, however the load crashes each time. and I don't get a script error. 

      I am sure there is way to load this in, possibly by grouping the table by week (and then linking), but I am not sure. 


      My table currently looks like below :


      Staff_Number,  DateOfShift, Reason,Hours_Worked, Cost_Of_Shift


      I think I need to group my table so it loads as a group table below:


      Staff Number,  WeekEndDate, Reason, Hours_Worked, Cost_Of_Shift



      If I am on the wrong path, please point me in the right direction, if not can you help with the above.  Can anyone help.


      Any help appreciated.