Group Table

[Anonymous]

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

[manojkulkarni]

It will be more clear if you put some sample files. it can be any form.

[Anonymous]

I have added a spreadsheet

[Kushal_Chawda]

Please see the attached

[Anonymous]

Hi

I can easily group it in the report.  I Need it to be grouped in the load script not in the report.

Regards

Phil

[Kushal_Chawda]

why you need it in load only?