IntervalMatch -- falling interval between two values

[#1]

Hello,

I 'm dealing with the need of a field that indicates the interval that match for each event row. For that, I have both table EVENTS and INTERVALS but I don't know how to use the intervalmatch() function (For now I made this calculation with nested IF). Could you help me pls?

Thanx!!

[Agis-Kalogiannis]

You could use something like:

intervalmatch(VALUE)

Load

MIN_VALUE, MAX_VALUE

Resident Interval_Table;

And join this table to the Intervalmatch table so as to eliminate the synthetic keys.

[#3]

Hello,

Following statement should give you desired result based on your data (Interval Match creates a synthetic key)

IntervalMatch(Value)Load MIN_VALUE,MAX_VALUE Resident Interval;

Thanks

Amit Prabhudesai

[demoustier]

Something like this ?

IntervallMatch is definitively the good option. Difficulties are coming from tables jointure.

test2 is result without synthetic key

[#5]

Thanx, but what if I want not only these two fields "MinValue" and "MaxValue" but the other fields from the events table? How can I merge it ?

[demoustier · Accepted solution]

like this ?

[#7]

It's perfect Demoustier! Thanx very much!!