Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Very simple question about IntervalMatch. I have used this long time back and I am struggling to get this working. I hope one of you can help me. The issue is IntervalMatch is returning One Row per specified Range. And this is returning incorrect values...
I am attaching the QV document for your reference.
Many thanks in advance.
Cheers - DV
Hi DV
I think the problem is the join after the intervalmatch. Change this join to:
Left JOIN (Raw_Data)
LOAD
LBound AS %_LBound,
UBound AS %_UBound,
RangeName
RESIDENT Beds_IntervalMatch;
You need the bounds to complete the join correctly.
Hope that helps
Jonathan