6 Replies Latest reply: Jan 23, 2012 10:41 AM by Nancy Reid RSS

    Need to create comparison difference table on load

    Nancy Reid

      Greetings Community!

      I need to load a table from a resident table that compares each possible [Type] within a group and calculates the difference for each metric.

      I have attached a sample file using types of apples. I have a table with multiple apple types within an orchard. I want to show the difference between each metric for each apple combination within each orchard. Can anyone help me with script to accomplish this.

       

      Data table looks like this:

       

      OrchardTypeWgtRating
      AFuji.323
      AGala.274
      AGranny.314
      ARed Del.283
      BFuji.332
      BGala.195
      BGranny.324
      BRed Del.355
      CFuji.334
      CGranny.293
      CRed Del.205

       

      Resulting table should look like this :

       

      OrchardApple AApple BWeight DifRating Dif
      AFujiGala0.05-1
      AFujiGranny0.01-1
      AFujiRed Del0.040
      AGalaGranny-0.040
      AGalaRed Del-0.011
      AGrannyRed Del0.031
      BFujiGala0.14-3
      BFujiGranny0.01-2
      BFujiRed Del-0.02-3
      BGalaGranny-0.131
      BGalaRed Del-0.160
      BGrannyRed Del-0.03-1
      CFujiGranny0.041
      CFujiRed Del0.13-1
      CGrannyRed Del0.09

      -2

       

      Thanks in advance!!