Joining tables with 'missing' data

samuel_brierley — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Joining tables with 'missing' data

Colin-Albert — Fri, 08 Jul 2016 16:21:03 GMT

You should find the answer here Generating Missing Data In QlikView

topic Re: Joining tables with 'missing' data in QlikView

Joining tables with 'missing' data

Re: Joining tables with 'missing' data