Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
Is there any chance to get data from two time set. I have table1 that contain times. Then I have another table2 that contains both times and measured values. Now I need to get those measured values somehow so first I get one timestamp from table1 and then compare timestamps with table2. So I need to get values from table2 plus minus 2 minutes compared to table1.
Pretty hard to explain this.
BR.
Timo
Load your table one and create intervals plus minus 2 minutes for each timestamp:
LOAD
Timestamp,
(Timestamp - Maketime(0,2)) as RangeStart,
(Timestamp + Maketime(0,2)) as RangeEnd
FROM Table1;
Then use IntervalMatch() to match the Table2 Timestamps into the ranges.
Hi Timo,
You can use intervalmatch to match the timestamp from table 1 to table 2 values.
Table 1 needs to have a start and end timestamp so the table 2 value can be matched.
for example on how to use it.
Felipe.