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

    Group Table

    Phil Speight

      Hi

       

      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.

       

       

      Phil