6 Replies Latest reply: Jan 15, 2018 5:21 AM by Ruben Marin RSS

    Interval Match help

    yusuuf rawat

      I have a table with

       

      Rate:

      Load * inline [

      Min , Max , Debit_Rate, Credit_rate

      .0 , 1000 , 10% , 20%........

      ];

       

      the rates only apply to monthly total so i loaded my data with group by statement

       

      Load Sum( Amt) as Total_for_month ,

              Debit_Or_Credit

               Month_year,

      resident transaction

      groub by   Debit_Or_Credit ,Month_year;

       

      interval match(Total_for_month )

      load Min ,

      Max

      resident Rate;

       

      the script runs without errors , but some of the results are incorrect .

       

      Sometimes people pass a second parameter in the interval match , when do i need to do that?

       

      Message was edited by: yusuuf rawat Attachment added Table needs to show on one line eg Merchant , debit , credit , rate1, rate 2 instread of same merchant on 2 lines The values are also incorrect