Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It will be more clear if you put some sample files. it can be any form.
I have added a spreadsheet
Please see the attached
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
why you need it in load only?