Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a simple sheet showing
Batch# , Table_Name ,Start_TIme ,End_Time, Rows_Loaded
to which I have added Duration using the function =interval(End_Time-Start_Time,'mm')
I want to now add in there the rate of load i.e Rows_Loaded / Duration
However the figure I end up seems to be applying the formula to all the records for that Table....not to that Batch#
Can someone please give me some advice? Thanks
Thank you Chris....you guys have confirmed what was slowly dawning on me that the formatting into minutes was creating a mask and that I should have dealt with the raw value from my duration. Understanding it as a fraction of a day has clarified the issue.
Thanks for the mention Mark.
Another good way of getting more granular with the logging is inserting into a table as you go, something like this:
Log:
LOAD
'Start Customer Table' as Step,
Date(now(), 'DD MMM YYYY hh:mm:ss') as Time
AUTOGENERATE(1)
;
At the end you could then do a resident load and a peek-1 to calculate the durations for each step.
It all depends how much information you require. You could also add other information to that table, such as row count of the last table loaded and system information such as machine and user name running the load. Information could be persisted by storing to a QVD with a date suffix.
Steve