Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
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.