1 Reply Latest reply: Jan 6, 2016 2:20 PM by Gysbert Wassenaar RSS

    summe of one way and back way

      Hi everyone. I have a round trip table, in which there is three colume"from" "to" "packets". I need to know between two punkt how many packets would be delivered. Sometime this is only one way between two cities.

       

      this is the table,

      fromtopackets
      AB100
      AC110
      AD60
      BA130
      BD120
      CA140

      this is the results that I want to have,

       

      BetweenPackets
      A - B230 = (100+130 )
      A - C250= (110 +140)
      A - D60
      B - D120

       

      What is Dimension? How to write expression?

      Thank you very much.

        • Re: summe of one way and back way
          Gysbert Wassenaar

          Try creating a new table in the script:

           

          Input:

          CrossTable(Destination,Value,2)

          LOAD RowNo() as Row, packets, from, to INLINE [

              from, to, packets

              A, B, 100

              A, C, 110

              A, D, 60

              B, A, 130

              B, D, 120

              C, A, 140

          ];

           

          Result:

          LOAD Row, packets, concat(Value, ' - ') as List

          Resident Input

          Group By Row, packets;

           

          Then use List as dimension and sum(packets) as expression.