4 Replies Latest reply: Feb 22, 2013 7:22 PM by Rob Wunderlich RSS

    Grouping with wild cards

    Bumin Koesesoy

      Hi ,

       

      I have the following problem:

       

      accounts:

      LOAD * INLINE [

          account, value

          A1000, 10000

          A2000, 5000

          B3000, -1000

          B2200, -750

          C7000, -800

      ];

       

      bipotab:

      LOAD * INLINE [

          bipo, text

          A, Sales

          B, CoS

          C, Admin

      ];

       

       

      as result I want to have

       

      SalesA100010000

      A20005000
      total
      15000
      CoSB2200-750

      B3000-1000
      total
      -1750
      AdminC7000-800
      total
      -800
      total
      12450

       

      is there any way to do this. I cannot use IntervalMatch because A,B,C are not numeric.

       

      thanks

      Bumin