*** IntervalMatch Issue ***

[IAMDV]

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

[jonathandienst]

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