Issue in Join Two Tables

[#1]

Hi,

Please find the attached excel file, which has three sheets,

First is rate slabe which has rates based on key [ Int_type, CCY] and range[ from balance and to balance] of balance.

Second is client data which has Int_type, CCY and balance, key field in both tables is Int_type & CCY.

and Third sheet has requried result, kindly guide me how i join or get requried result.

Regards,

Zain.

[#2]

Zain, you would need to use Interval Match to apply the bucket method you have got in the data.

[#3]

Dear,

let me know one more thing interval Match do work like between >= and <=, i need >  and <= so can i do with interval match plz reply with an example or any reference.

Regards,

Zain