11 Replies Latest reply: May 15, 2014 10:08 AM by chickenjoy _ RSS

    Multiple records question

    chickenjoy _

      Hello All,

       

      If a row item comes in as a range of boxes is there a way to split that out as multiple records and copy the data for each record?  We sometimes get ranges of boxes but they all have the same product in each box.  I want to separate each box into multiple line items of the same data.

       

      Here is the link of the table:

       

      http://i225.photobucket.com/albums/dd38/peytimuti/test.jpg[/url]

        • Multiple records question
          Olly Bond

          Hello chickenjoy,

           

          Your data doesn't look tricky - it's very regular, all the cells are populated, trapping should be easy. To advise on how to extract it, it would be helpful to know what you want.

           

          Do you want:

           

          Style - Small - Medium - Large

          Poc... - 132 - 12 - 108[/CODE]

           

          That would be best handled with a summary. There are alternatives that might require a multi-column region trick to artificially generate duplicate records before filtering based on a logical test, but it doesn't look like you'll need them here.

           

          Best wishes,

           

          Olly

            • Multiple records question
              Olly Bond

              Hello chickenjoy,

               

              Thanks to Kruncher for pointing out that your question was clear - apologies for missing the meaning of "boxes" last night. Somehow I thought you meant table cells when it should have meant cartons.

               

              Yes, you can get data like this:

               

              Style     Size     Description     Price     CtnNo     Ctns     Units     Total      Weight     Total      Dimensions     Column     Lower     Upper

              5877     Small     Pocahottie     24.95     1     1     12     12     11.7     11.6     20x14x6          1     1     1

              5877     Small     Pocahottie     24.95     2-6     5     24     120     22.75     113.75     19x14x17     2     2     6

              5877     Small     Pocahottie     24.95     2-6     5     24     120     22.75     113.75     19x14x17     3     2     6

              5877     Small     Pocahottie     24.95     2-6     5     24     120     22.75     113.75     19x14x17     4     2     6

              5877     Small     Pocahottie     24.95     2-6     5     24     120     22.75     113.75     19x14x17     5     2     6

              5877     Small     Pocahottie     24.95     2-6     5     24     120     22.75     113.75     19x14x17     6     2     6

              5877     Large     Pocahottie     24.95     7-10     4     24     96     23.9     95.6     19x14x17     7     7     10

              5877     Large     Pocahottie     24.95     7-10     4     24     96     23.9     95.6     19x14x17     8     7     10

              5877     Large     Pocahottie     24.95     7-10     4     24     96     23.9     95.6     19x14x17     9     7     10

              5877     Large     Pocahottie     24.95     7-10     4     24     96     23.9     95.6     19x14x17     10     7     10

              5877     Medium     Pocahottie     24.95     11     1     12     12     12     12     20x14x6          11     11     11

              5877     Large     Pocahottie     24.95     12     1     12     12     12.1     12.1     20x14x6          12     12     12[/CODE]

               

              To do this, define your detail template with the multi-column region active, using 40 columns of 1 character width each, starting in column 100 or higher, to the right of your data. Then define a calculated field called Lower as val(lsplit(CtnNo;2;"-";1)) and Upper as val(rsplit(CtnNo;2;"-";1)). Then a filter using the expression Column()>=Lower .and. Column()<=Upper should give you the data you're after.

               

              HTH,

               

              Olly