Intervalmatch negative values

ingo_lsg — Mon, 23 Sep 2019 15:32:28 GMT

Dear folks,

I am trying to use intervalmatch with negative values, as well.

Unfortunately only my positive intervals get matched.

Any ideas?

Here is some code sample:

Time_Intervals:

Load * Inline [
Start, End, Cluster, FR24.event

0, 0, ZERO, gate_arrival

1, 5, >=1 <=5 MIN, gate_arrival
6, 15, >=6 <=15 MIN, gate_arrival
16, 30, >=16 <=30 MIN, gate_arrival
31, 60, >=31 <=60 MIN, gate_arrival
61, 120, >1h <=2h, gate_arrival
121,300, >2h <=5h, gate_arrival
301, 600, >5h <=10h, gate_arrival
600, 10000, >10h, gate_arrival

-1, -5, <=-1 >=-5 MIN, gate_arrival
-6, -15, <=-6 >=-15 MIN, gate_arrival
-16, -30, <=-16 >=-30 MIN, gate_arrival
-31, -60, <=-31 >=-60 MIN, gate_arrival
-61, -120, <-1h >=-2h, gate_arrival
-121,-300, <-2h >=-5h, gate_arrival
-301, -600, <-5h >=-10h, gate_arrival
-600, -10000, <-10h, gate_arrival

0, 0, ZERO, gate_departure

1, 5, >=1 <=5 MIN, gate_departure
6, 15, >=6 <=15 MIN, gate_departure
16, 30, >=16 <=30 MIN, gate_departure
31, 60, >=31 <=60 MIN, gate_departure
61, 120, >1h <=2h, gate_departure
121,300, >2h <=5h, gate_departure
301, 600, >5h <=10h, gate_departure
600, 10000, >10h, gate_departure

-1, -5, <=-1 >=-5 MIN, gate_departure
-6, -15, <=-6 >=-15 MIN, gate_departure
-16, -30, <=-16 >=-30 MIN, gate_departure
-31, -60, <=-31 >=-60 MIN, gate_departure
-61, -120, <-1h >=-2h, gate_departure
-121,-300, <-2h >=-5h, gate_departure
-301, -600, <-5h >=-10h, gate_departure
-600, -10000, <-10h, gate_departure
];

Join(Time_Intervals)
IntervalMatch(DeltaMinutes, FR24.event)
Load
Start,
End,
[FR24.event]
Resident Time_Intervals;

Re: Intervalmatch negative values

Vegar — Mon, 23 Sep 2019 17:24:22 GMT

You need to switch the values start and end for the negative values in your inline table.

-5 is smaller than -1.

Re: Intervalmatch negative values

ingo_lsg — Tue, 24 Sep 2019 07:56:32 GMT

great! That worked!

Sure the start dimension has to start with the smallest value.

Is the sorting of the intervals also important?

Re: Intervalmatch negative values

Vegar — Tue, 24 Sep 2019 09:59:01 GMT

I have never had issues with the sort order, so I don't think it has any effect on the result.

topic Re: Intervalmatch negative values in App Development

Intervalmatch negative values

Re: Intervalmatch negative values

Re: Intervalmatch negative values

Re: Intervalmatch negative values