Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
first of all thanks for any help on the subject.
i have a system that reports upon change. essentially the system will only provide a record when the value has changed. considering the below table, although their is no data i know that the value in the 'missing' minutes is 1.
[Time],[Value]
01:00, 1
01:05,2
my question is how do i fill in the gaps. my inexperienced answer is to merge it with a master time table where if their is no match take the previous record but i haven't a clue how to do that.
below is my data load script and my master time script if this helps.
LOAD
MakeTime(hour([Date / Time]), Minute([Date / Time])) as Time,
Value,
FROM
[XXX\April 2015.xlsx]
(ooxml, embedded labels, table is [01 Apr]);
TimeField:
Load
Time((1/24/60) * RowNo()) as Time
Autogenerate ( 24 * 60 );
You should find the answer here Generating Missing Data In QlikView