4 Replies Latest reply: May 15, 2014 10:11 AM by Mihai _ RSS

    Trap just a part from a block of identically formatted information

      Hello

       

      From the example I need to extract the information (Mat. Comp. Number) between entry „Material Components Not Assigned” and the Date line „01.12.2099”. As you can see this information is identically formatted as the information before „Material Components Not Assigned” so I don’t know how to trap just the Information that I need. I used Monarch v 8. Some rows are wraped.

       

      Thank you.

       

      01.12.2099                                                                            Task List Print List                                                                                46

      -


      Material 001110000100                                           Plant 1000

               Material name abc

      Group    50006134           Grp.ct 1    Material name abc

               LSize From                0    LSize To       99.999.999      PC

               Use        1                   Status   4         Plant1000

      -


      Sequence   0      Seq. Cat.  Std.seq.

      Operation  0010  Work Ctr    01-CUT01  0,330 - cutting

                        Ctrl Key    ZP02

                        Base Qty                   1  PC

                        labor time       0,446  MIN  mach.  time      0,446  MIN

                        tact time               MIN  Additional              MIN

                        Allocated               MIN  Groupnr                 ZGR

        Mat. Comp. 999999999001               sewing thread black

            BOM No.  00088019  Alt. 1  Item      0090 Qty                  12    M

            Level 02 Path01

        Mat. Comp. 999999999002               Welt Cover

            BOM No.  00088019  Alt. 1  Item      0100 Qty                   4    PC

            Level 02 Path01

      -


      Material Components Not Assigned:

      -


        Mat. Comp. 999999999003               Belt red

            BOM No.  00088534  Alt. 1  Item      0010 Qty               0,220    M

            Level 03 Path02

        Mat. Comp. 999999999004               Assy Tongue

            BOM No.  00088019  Alt. 1  Item      0110 Qty                   1    PC

            Level 02 Path01

      01.12.2099                                                                            Task List Print List                                                                                47

      -


      Material 001110000200                                           Plant 1000

        • Trap just a part from a block of identically formatted information
          Olly Bond

          Hello Mihai, and welcome,

           

          You can trap the "Material Component" line separately as an Append template, and then filter in the Table window your detail records based on which ones have an empty Append field. Alternatively, depending on your data format (I'd need to see a longer sample) using a Page Header template might be helpful.

           

          Best wishes,

           

          Olly

            • Trap just a part from a block of identically formatted information

              Hello Olly,

               

              Thank you for the replay. I tried your sugestion but it didn't work. Here is a more complete sample with the result that I need.

               

              01.12.2099                                                                             Task List Print List                                                                                1

               

              -


               

              Material 001110000100                                           Plant 1000

               

                       Material name abc

               

              Group    50006169           Grp.ct 1    Material name abc

               

                       LSize From                0    LSize To       99.999.999      PC

               

                       Use        1                   Status   4         Plant1000

               

              -


               

              Sequence   0      Seq. Cat.  Std.seq.

               

              Operation  0005  Work Ctr    01-HFW02

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,744  MIN  mach.  time      0,744  MIN

               

                                tact time        0,744  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0010  Work Ctr    01-HFW02  Summarization Shield Welding

               

                                Ctrl Key    ZP04

               

                                Base Qty                   1  PC

               

                                labor time              MIN  mach.  time             MIN

               

                                tact time        0,744  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0020  Work Ctr    01-PHK06  0,234 - assembly extension sword

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,186  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0030  Work Ctr    01-PHK06  0,234 - assembly extension sword

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,233  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0040  Work Ctr    01-TAM02

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,763  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0050  Work Ctr    01-PHK06  0,234 - assembly extension sword

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,409  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0060  Work Ctr    01-SEW01  0,433 - sewing mirtil

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,233  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0070  Work Ctr    02-AFL02  0,665 - assembly shield

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,949  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0080  Work Ctr    02-AFL02  0,888 - assembly Handle of sword

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,326  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0090  Work Ctr    02-PCA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,023  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0100  Work Ctr    02-ACC01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,270  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0110  Work Ctr    02-FCO09

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,605  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0120  Work Ctr    02-FCO09

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       3,534  MIN  mach.  time             MIN

               

                                tact time        3,534  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0130  Work Ctr    02-FCO09  Summarization of armour

               

                                Ctrl Key    ZP01

               

                                Base Qty                   1  PC

               

                                labor time       9,272  MIN  mach.  time             MIN

               

                                tact time        3,534  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

                Mat. Comp. 993600622200               Iron ore

               

                    BOM No.  00086251  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 00 Path00

               

                Mat. Comp. 993600329600               Silver ore

               

                    BOM No.  00086251  Alt. 1  Item      0020 Qty               1,400    M

               

                    Level 00 Path00

               

                Mat. Comp. 993600559300               Hocus Pocus

               

                    BOM No.  00086251  Alt. 1  Item      0030 Qty               0,400    PC

               

                    Level 00 Path00

               

              -


               

              Material Components Not Assigned:

               

              -


               

              01.12.2099                                                                             Task List Print List                                                                                2

               

              -


               

              Material 001110000101                                           Plant 1000

               

                       Material name def

               

              Group    50006415           Grp.ct 1    Material name def

               

                       LSize From                0    LSize To       99.999.999      PC

               

                       Use        1                   Status   4         Plant1000

               

              -


               

              Sequence   0      Seq. Cat.  Std.seq.

               

              Operation  0005  Work Ctr    01-HFW02

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,744  MIN  mach.  time      0,744  MIN

               

                                tact time        0,744  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0010  Work Ctr    01-HFW02  Summarization Welding

               

                                Ctrl Key    ZP04

               

                                Base Qty                   1  PC

               

                                labor time              MIN  mach.  time             MIN

               

                                tact time        0,744  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0020  Work Ctr    01-PHK08

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,186  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0030  Work Ctr    01-PHK08  0,225 - coining extension

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,233  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0040  Work Ctr    01-TAM02

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,372  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0050  Work Ctr    01-PHK08

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,409  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0060  Work Ctr    01-SEW01  0,433 - sewing of mirtil shirt

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,233  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0070  Work Ctr    02-AFL02  0,665 - assembly boots

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,949  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0080  Work Ctr    02-AFL02

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,326  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0090  Work Ctr    02-FAS05

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,023  MIN  mach.  time             MIN

               

                                tact time        1,023  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0100  Work Ctr    02-AFL02

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,270  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0110  Work Ctr    02-FCO10

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,605  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0120  Work Ctr    02-FCO10

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,093  MIN  mach.  time             MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0130  Work Ctr    02-FAS05  Summarization of boot production

               

                                Ctrl Key    ZP01

               

                                Base Qty                   1  PC

               

                                labor time       5,441  MIN  mach.  time             MIN

               

                                tact time        1,023  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

                Mat. Comp. 993600118900               Iron ore

               

                    BOM No.  00086252  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 00 Path00

               

                Mat. Comp. 993600338500               Silver ore

               

                    BOM No.  00086252  Alt. 1  Item      0020 Qty               1,400    M

               

                    Level 00 Path00

               

                Mat. Comp. 993600626600               Coal

               

                    BOM No.  00086252  Alt. 1  Item      0030 Qty               0,400    PC

               

                    Level 00 Path00

               

                Mat. Comp. 993600009900               Hocus Pocus

               

                    BOM No.  00086252  Alt. 1  Item      0040 Qty               0,010    PC

               

                    Level 00 Path00

               

              -


               

              Material Components Not Assigned:

               

              -


               

              01.12.2099                                                                             Task List Print List                                                                                46

               

              -


               

              Material 001110000102[/B]                                           Plant 1000

               

                       Material name ghi

               

              Group    50006134           Grp.ct 1    Material name ghi

               

                       LSize From                0    LSize To       99.999.999      PC

               

                       Use        1                   Status   4         Plant1000

               

              -


               

              Sequence   0      Seq. Cat.  Std.seq.

               

              Operation  0010  Work Ctr    01-CUT01  0,330 - cutting steel strips

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,446  MIN  mach.  time      0,446  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0020  Work Ctr    02-SAW03  0,120 - cutting belt to length

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,093  MIN  mach.  time      0,093  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0030  Work Ctr    02-SAW03  0,060 - cutting belt

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,047  MIN  mach.  time      0,047  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0040  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,400  MIN  mach.  time      0,400  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0050  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,521  MIN  mach.  time      0,521  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0060  Work Ctr    02-ARA01  0,133 - pre assembly shield

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,186  MIN  mach.  time      0,186  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0070  Work Ctr    02-SEW25  0,470 - sewing mirtil pants

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,400  MIN  mach.  time      0,400  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0080  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,860  MIN  mach.  time      1,860  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0090  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,395  MIN  mach.  time      1,395  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0100  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,116  MIN  mach.  time      1,116  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0110  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       2,511  MIN  mach.  time      2,511  MIN

               

                                tact time        2,511  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0120  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,465  MIN  mach.  time      0,465  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0130  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,930  MIN  mach.  time      0,930  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0140  Work Ctr    02-TOB01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,698  MIN  mach.  time      0,698  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0150  Work Ctr    02-ABE01  0,600 - inserting belt

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,558  MIN  mach.  time      0,558  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0160  Work Ctr    02-ABE01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,023  MIN  mach.  time      1,023  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0170  Work Ctr    02-ABE01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,465  MIN  mach.  time      0,465  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0180  Work Ctr    02-SEW25  Summarization shield production

               

                                Ctrl Key    ZP01

               

                                Base Qty                   1  PC

               

                                labor time      13,113  MIN  mach.  time     13,113  MIN

               

                                tact time        2,511  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

                Mat. Comp. 991400001600               adjuster

               

                    BOM No.  00087993  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 03 Path04

               

                Mat. Comp. 897000001602               pipe

               

                    BOM No.  00088038  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 03 Path04 Phantom Assembly

               

                Mat. Comp. 990000867900               Upper part painted

               

                    BOM No.  00088132  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 02 Path02

               

                Mat. Comp. 991900769900               Light

               

                    BOM No.  00088895  Alt. 1  Item      0010 Qty               4,320    M

               

                    Level 03 Path03

               

                Mat. Comp. 990500888400               Belt Material

               

                    BOM No.  00088533  Alt. 1  Item      0010 Qty               0,280    M

               

                    Level 03 Path01

               

                Mat. Comp. 990500234900               Dwarves Logo

               

                    BOM No.  00088019  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 02 Path01

               

                Mat. Comp. 897200200101               Side part

               

                    BOM No.  00087430  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 02 Path01 Phantom Assembly

               

                Mat. Comp. 897600000500               Index F

               

                    BOM No.  00086335  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 01 Path01 Phantom Assembly

               

                Mat. Comp. 990900003905               Slider

               

                    BOM No.  00087993  Alt. 1  Item      0020 Qty                   1    PC

               

                    Level 03 Path04

               

                Mat. Comp. 990501109100               Leather Cover

               

                    BOM No.  00088019  Alt. 1  Item      0100 Qty                   4    PC

               

                    Level 02 Path01

               

              -


               

              Material Components Not Assigned:

               

              -


               

                Mat. Comp. 990500901400[/B]               Belt Material

               

                    BOM No.  00088534  Alt. 1  Item      0010 Qty               0,220    M

               

                    Level 03 Path02

               

                Mat. Comp. 992200666802[/B]               Assy Tongue

               

                    BOM No.  00088019  Alt. 1  Item      0110 Qty                   1    PC

               

                    Level 02 Path01

               

              01.12.2099                                                                             Task List Print List                                                                                47

               

              -


               

              Material 001110000103[/B]                                           Plant 1000

               

                       Material name jkl

               

              Group    50006134           Grp.ct 1    Material name jkl

               

                       LSize From                0    LSize To       99.999.999      PC

               

                       Use        1                   Status   4         Plant1000

               

              -


               

              Sequence   0      Seq. Cat.  Std.seq.

               

              Operation  0010  Work Ctr    01-CUT01  0,330 - cutting leather

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,446  MIN  mach.  time      0,446  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0020  Work Ctr    02-SAW03  0,120 - cutting belt to length

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,093  MIN  mach.  time      0,093  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0030  Work Ctr    02-SAW03  0,060 - cutting belt band to length

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,047  MIN  mach.  time      0,047  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0040  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,400  MIN  mach.  time      0,400  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0050  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,521  MIN  mach.  time      0,521  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0060  Work Ctr    02-ARA01  0,133 - pre assembly leather

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,186  MIN  mach.  time      0,186  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0070  Work Ctr    02-SEW25  0,470 - sewing zip

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,400  MIN  mach.  time      0,400  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0080  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,860  MIN  mach.  time      1,860  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0090  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,395  MIN  mach.  time      1,395  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0100  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,116  MIN  mach.  time      1,116  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0110  Work Ctr    02-SEW25

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       2,511  MIN  mach.  time      2,511  MIN

               

                                tact time        2,511  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0120  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,465  MIN  mach.  time      0,465  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0130  Work Ctr    02-ARA01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,930  MIN  mach.  time      0,930  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0140  Work Ctr    02-TOB01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,698  MIN  mach.  time      0,698  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0150  Work Ctr    02-ABE01  0,600 - inserting belt band

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,558  MIN  mach.  time      0,558  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0160  Work Ctr    02-ABE01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       1,023  MIN  mach.  time      1,023  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0170  Work Ctr    02-ABE01

               

                                Ctrl Key    ZP02

               

                                Base Qty                   1  PC

               

                                labor time       0,465  MIN  mach.  time      0,465  MIN

               

                                tact time               MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

              Operation  0180  Work Ctr    02-SEW25  Summarization of production

               

                                Ctrl Key    ZP01

               

                                Base Qty                   1  PC

               

                                labor time      13,113  MIN  mach.  time     13,113  MIN

               

                                tact time        2,511  MIN  Additional              MIN

               

                                Allocated               MIN  Groupnr                 ZGR

               

                Mat. Comp. 992200904900               Assy Tongue

               

                    BOM No.  00088134  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 02 Path03

               

                Mat. Comp. 992300704900               Zipper endless

               

                    BOM No.  00088904  Alt. 1  Item      0010 Qty               1,225    M

               

                    Level 03 Path04

               

                Mat. Comp. 990600677900               Upper part painted

               

                    BOM No.  00088133  Alt. 1  Item      0010 Qty                   1    PC

               

                    Level 02 Path02

               

                Mat. Comp. 990530753300               Strip b

               

                    BOM No.  00088019  Alt. 1  Item      0070 Qty               1,500    M

               

                    Level 02 Path01

               

                Mat. Comp. 991900111100               Cut Welt

               

                    BOM No.  00088019  Alt. 1  Item      0080 Qty                   2    PC

               

                    Level 03 Path03 Phantom Assembly

               

                Mat. Comp. 991400019000               sewing thread Strongsilver

               

                    BOM No.  00088019  Alt. 1  Item      0090 Qty                  12    M

               

                    Level 02 Path01

               

                Mat. Comp. 990500345100               Cover 50

               

                    BOM No.  00088019  Alt. 1  Item      0100 Qty                   4    PC

               

                    Level 02 Path01

               

              -


               

              Material Components Not Assigned:

               

              -


               

                Mat. Comp. 990500882400[/B]               Belt Material

               

                    BOM No.  00088534  Alt. 1  Item      0010 Qty               0,220    M

               

                    Level 03 Path02

               

                Mat. Comp. 992200608802[/B]               Assy Tongue

               

                    BOM No.  00088019  Alt. 1  Item      0110 Qty                   1    PC

               

                    Level 02 Path01[/CODE]

               

              The result should be:

              Product              Product name              Mat nr               Mat name

              001110000102     Material name ghi     990500901400     Belt Material

              001110000102     Material name ghi     992200666802     Assy Tongue

              001110000103     Material name jkl      990500882400     Belt Material

              001110000103     Material name jkl      992200608802     Assy Tongue

               

              001110000100 and 001110000101 have no not assigned components so they are not intersting.

                • Trap just a part from a block of identically formatted information
                  Olly Bond

                  Hello Mihai,

                   

                  With three templates, you can get what you need.

                   

                  First, the Detail template, selecting just the lines in the report with Mat. Comp. appearing. On this I defined the Mat # and Mat Name fields.

                   

                  The next template is an Append template based on a three line sample, where the trap is on line 1 of 3 and looks for the word Material followed by a numeric character. Here I picked out the Product # and Product Name.

                   

                  Thirdly, define an additional Append template that looks for the Components Not Assigned row. Set this template to be Cleared By the other Append template (you'll need v10 and above for this).

                   

                  Then you can filter out those records which don't have a field from the Components Not Assigned template.

                   

                  If you drop me an email I'll happily send you the model as that might make it clearer.

                   

                  Best wishes,

                   

                  Olly