topic IntervalMatch in App Development

IntervalMatch

olgaavalos — Mon, 12 Dec 2022 20:05:21 GMT

Hi,

I am working with IntervalMatch but the registers of the table does not load.

The intervals are:

The value is:

SCRIPT

Transacciones:
LOAD
amount1

FROM [lib://CuanticaSoft:DataFiles/Transacciones.qvd]
(qvd);

Rangos:
LOAD
Rango_Inf,
Rango_Sup,
Id_Rangos
FROM [lib://CuanticaSoft:DataFiles/Rangos.qvd]
(qvd)
Where not Id_Rangos like 1 and not Id_Rangos like 53
;

Inner Join IntervalMatch(amount1)
Load Rango_Inf,
Rango_Sup
Resident Rangos;

Re: IntervalMatch

barnabyd — Mon, 12 Dec 2022 21:00:15 GMT

G'day @olgaavalos,

I think everything looks good except that you need to put the smaller value first in the IntervalMatch statemtent:

Inner Join IntervalMatch(amount1) Load Rango_Sup, Rango_Inf Resident Rangos;

I also noticed that your 'where' could have been written more efficiently like this:

Where Id_Rangos > 1 and Id_Rangos < 53;

or this:

Where match( Id_Rangos, 1, 53 ) = 0;

I hope this helps.

Cheers, Barnaby.