Using the IntervalMatch Function

[#1]

How to Get the Actual_Rate between using the From_Balance and To_Balance.

[chematos]

something like that:

Table:

load * inline[

Id, From_Balance , To_Balance

1, -0.1, 4999999

2, 50000000, 999999999

....

]

inner join intervalmatch(Balance)

load From_Balance , To_Balance

from table;

[#3]

I got through this script..,

Rate_Slab:

LOAD 

     FROM_BALANCE,

     TO_BALANCE,

     INT_TYPE,

     CCY,

     ACTUAL_RATE

FROM

C:\Users\Administrator\Downloads\Rate_Matrix2.xls

(biff, embedded labels, table is [Rate Slab$]);

Client_Data:

LOAD ClientNo,

     INT_TYPE,

     CCY,

     Balance,

     F5

FROM

C:\Users\Administrator\Downloads\Rate_Matrix2.xls

(biff, embedded labels, table is [Client Data$]);

Left Join(Rate_Slab)

IntervalMatch(Balance) Load FROM_BALANCE+1,

     TO_BALANCE

     Resident Rate_Slab

     Where CCY='PKR' and (INT_TYPE='ISI' or INT_TYPE='PLS');