I have a log file that containsthe following column sRECORD_ID, START_TIME and END_TIME ;
Record_ID
START_TIME
END_TIME
1234
08/02/2012 16:43:15
08/02/2012 17:02:08
As part of the load process, I need to create a line of data for EVERY MINUTE that the report was actually open and create this as a DATETIMEKEY column.
I have tried to use the IterNo() function and DO Loop but not having much joy – This is what I am trying to achieve:
You could auto-generate a calendar + time for every date / time combination that you could have and then inner join that to your data set using IntervalMatch.
You could auto-generate a calendar + time for every date / time combination that you could have and then inner join that to your data set using IntervalMatch.
