3 Replies Latest reply: Apr 25, 2013 4:58 PM by bayraktar RSS

    interval match

      I am tried to use interval match to combine 2 tables.

      It did not worked when I tried to combine alphanumeric fields such as cost centers.It worked for numeric fields such as account numbers.

      Is there any other way to combine alphanumeric fields with interval match?

        • Re: interval match
          Stefan Wühl

          Intervalmatch only works for numeric fields.

           

          How do you want you alphanumeric fields matched? What kind of interval should your alphanumeric values - that define this interval - span (i.e. if your limits are A and B, what values should be generated for your interval?)?

            • Re: interval match

              I have one table with account ,cost center ,value and date , another table account range, cost center range, row, market .

              I need to have value total by row and market. You can see data below tables.

              If needed there are two more tables one for all valid accounts , second for all valid cost centers.

              Cost centers are like C100, C120,D100,D200...

               

              row








































              accountcost centeramountperiodyear
              111C10010012013
              112C11020012013
              114C20030012013
              115D20020022013
              200F21020022013

                marketacc1
                acc2
                cc1
                cc2


                1406
                2888
                100
                199
                C100
                C199


                1406
                5888
                100
                199
                C200
                ZZZZ


                1500
                2888
                200
                299
               
                ZZZZ

              • Re: interval match

                Pls find the samples within the attached files