2 Replies Latest reply on Nov 25, 2013 4:14 PM by wluther

    Two Custom Pollers - need to join into one table

    darrell.miller

      hi, i have two custom pollers, one pulls a group of table headers from the multifunction copier/printer/scanner/fax/monstrosity, the other poller pulls the actual values. i'd like to join them into one table..

      is there an easy way to do this?

       

      poller one returns this:

       

      prtMarkerSuppliesDescription - LabelprtMarkerSuppliesDescription
      1.1Toner (Cyan)
      1.2Toner (Magenta)
      1.3Toner (Yellow)
      1.4Toner (Black)
      1.5Drum Cartridge (Cyan)
      1.6Developer Cartridge (Cyan)
      1.7Drum Cartridge (Magenta)
      1.8Developer Cartridge (Magenta)
      1.9Drum Cartridge (Yellow)
      1.1Developer Cartridge (Yellow)
      1.11Drum Cartridge (Black)
      1.12Developer Cartridge (Black)
      1.13Waste Toner Box
      1.14Fusing Unit
      1.15Image Transfer Belt Unit
      1.16Transfer Roller Unit
      1.17Ozone Filter
      1.18Toner Filter
      1.19Staple Cartridge

       

      poller 2 returns this.

      prtMarkerSuppliesLevel - LabelprtMarkerSuppliesLevel
      1.199
      1.2100
      1.3100
      1.499
      1.599
      1.699
      1.799
      1.899
      1.999
      1.199
      1.1199
      1.1299
      1.13-3
      1.1499
      1.1599
      1.1699
      1.1799
      1.1899
      1.19-3

       

      and i would like it to look display like this:

      SupplyValue
      Toner (Cyan)99
      Toner (Magenta)100
      Toner (Yellow)100
      Toner (Black)99
      (you get the idea)

       

      any suggestions would be greatly appreciated.