Joining tables with 'missing' data

[samuel_brierley]

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 );

[Colin-Albert]

You should find the answer here   Generating Missing Data In QlikView