Concatenating tables based on dates

[Anonymous]

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]

maybe

a:

load * inline [

ID, Start, End, Service

123,1.1,30.1,TTR

123,15.1,30.1,Boost

];

b:

NoConcatenate

load

  ID,

  Start,

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

  Service

Resident

  a

order by ID, Start desc;

DROP Table a;