7 Replies Latest reply on Oct 27, 2016 6:47 AM by beverly

    Returns a list of box # all containing an item in a search

    dennisbuitelaar

      Hi,

       

      I would to write a script that returns a complete list of box numbers containing the same item but also shows other items in these boxes.

       

      Shipment     Box #    Item   

      A                  123        abc

      A                  123        def

      A                  456        klm

      B                  478       abx

      B                  478       lan

      B                  479       ghi

      C                  501      abc

      C                  501      cuz

       

      When searching for item "abc" I want a list of box numbers returned including all items, so return find should be box # 123 and 501

      A                  123        abc

      A                  123        def

      C                  501      abc

      C                  501      cuz

       

      Anyone able to help?

       

      Thanks,