topic Re: Issue in Join Two Tables in QlikView

Issue in Join Two Tables

Wed, 05 Sep 2012 11:53:01 GMT

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.

Re: Issue in Join Two Tables

Wed, 05 Sep 2012 12:27:54 GMT

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

Re: Issue in Join Two Tables

Thu, 06 Sep 2012 04:40:04 GMT

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