Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
like this ?
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.
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
Something like this ?
IntervallMatch is definitively the good option. Difficulties are coming from tables jointure.
test2 is result without synthetic key
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 ?
like this ?
It's perfect Demoustier! Thanx very much!!