Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;