topic Concatenating tables based on dates in QlikView

Concatenating tables based on dates

Anonymous — Mon, 19 Jan 2015 14:48:37 GMT

hi,

i would like to take a table, and concatenate records with each other,

only if there is an overlap with the dates.

dates are in start - end (as against to daily represntation)

how can i turn the raw table (on the right), to the table on the left?

Thank You,

Nir

maxgro — Mon, 19 Jan 2015 20:12:28 GMT

maybe

load * inline [

ID, Start, End, Service

123,1.1,30.1,TTR

123,15.1,30.1,Boost

];

NoConcatenate

load

ID,

Start,

if(ID=peek(ID) and End=peek(End), Peek(Start), End) as End,

Service

Resident

order by ID, Start desc;

DROP Table a;