Link the columns start(time) and end(time) (they're timestamps from a file) to a manually created column, let's call it MinuteID.
Expected result: To each MinuteID are all rows linked which have a start(time) <= MinuteID and an end(time) >= MinuteID. Which includes that one MinuteID can occur multiple times with different files (start/end combinations)
I wrote my code and in 95% it runs fine. But in 5% the data isn't linked by intervalmatch - it seems like all of that 5% have a start(time) where the minute is 00 (for example 14:00:35). But there are also cases where minute 00 is no problem.
Re: Intervalmatch doesn't link all data as expected
I found the problem. It was simple but hidden deep. There was just no data to match. If you format the MinuteID as DateTime everything was fine. Even if you format it as decimal - but you had to set the number of decimals after decimal point to 14 digits to see that the MinuteID was < than the start(time). Because of the fact that the duration (endtime - starttime) was less than one minute even the next MinuteId was not in range. So it didin't match.