7 Replies Latest reply: May 15, 2014 9:52 AM by Grant Perkins RSS

    Horizontal / Vertical

      Hi all,

       

      is somebody here to give me a kick to start from here:

       

      [font="courier"]mei        2004 (2DBA 2pk do/bl/ac/wc)                                                                               

      1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31           

        14  14  14  14  14  14  14  12  12  12  14  14  14  14  13  13  13  12  12  12  12  13  13  13  16  16  16  16  11  11  11 All.      

         -   -   -   -   -   -  12   2   2   2   2   2   2   2   1   1   1   -   -   -   -   -   -   -   -   -   -   -   -   -   - Av.       

        14  14  14  14  14  14   2  10  10  10  12  12  12  12  12  12  12  12  12  12  12  13  13  13  16  16  16  16  11  11  11 Sold       /font[/quote]and coming to this:

       

      [font="courier"]Name     Type     Day     All     Sold

      SIPEG     2DBA      1     14     14

      SIPEG     2DBA      2     14     14

      SIPEG     2DBA      3     14     14

      SIPEG     2DBA      4     14     14

      SIPEG     2DBA      5     14     14

      SIPEG     2DBA      6     14     14

      SIPEG     2DBA      7     14      2

      SIPEG     2DBA      8     12     10

      SIPEG     2DBA      9     12     10

      SIPEG     2DBA     10     12     10

      SIPEG     2DBA     11     14     12

      SIPEG     2DBA     12     14     12

      SIPEG     2DBA     13     14     12

      SIPEG     2DBA     14     14     12

      SIPEG     2DBA     15     13     12

      SIPEG     2DBA     16     13     12

      SIPEG     2DBA     17     13     12

      SIPEG     2DBA     18     12     12

      SIPEG     2DBA     19     12     12

      SIPEG     2DBA     20     12     12

      SIPEG     2DBA     21     12     12

      SIPEG     2DBA     22     13     13

      SIPEG     2DBA     23     13     13

      SIPEG     2DBA     24     13     13

      SIPEG     2DBA     25     16     16

      SIPEG     2DBA     26     16     16

      SIPEG     2DBA     27     16     16

      SIPEG     2DBA     28     16     16

      SIPEG     2DBA     29     11     11

      SIPEG     2DBA     30     11     11

      SIPEG     2DBA     31     11     11

       

        /font[/quote]Any thoughts will be appreciated, because I have no idea.  smile.gif[/img] 

       

      Regards

      Rolf

        • Horizontal / Vertical

          Hi all,

           

          is somebody here to give me a kick to start from here:

           

          [font="courier"]mei        2004 (2DBA 2pk do/bl/ac/wc)                                                                               

          1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31           

            14  14  14  14  14  14  14  12  12  12  14  14  14  14  13  13  13  12  12  12  12  13  13  13  16  16  16  16  11  11  11 All.      

             -   -   -   -   -   -  12   2   2   2   2   2   2   2   1   1   1   -   -   -   -   -   -   -   -   -   -   -   -   -   - Av.       

            14  14  14  14  14  14   2  10  10  10  12  12  12  12  12  12  12  12  12  12  12  13  13  13  16  16  16  16  11  11  11 Sold       /font[/quote]and coming to this:

           

          [font="courier"]Name     Type     Day     All     Sold

          SIPEG     2DBA      1     14     14

          SIPEG     2DBA      2     14     14

          SIPEG     2DBA      3     14     14

          SIPEG     2DBA      4     14     14

          SIPEG     2DBA      5     14     14

          SIPEG     2DBA      6     14     14

          SIPEG     2DBA      7     14      2

          SIPEG     2DBA      8     12     10

          SIPEG     2DBA      9     12     10

          SIPEG     2DBA     10     12     10

          SIPEG     2DBA     11     14     12

          SIPEG     2DBA     12     14     12

          SIPEG     2DBA     13     14     12

          SIPEG     2DBA     14     14     12

          SIPEG     2DBA     15     13     12

          SIPEG     2DBA     16     13     12

          SIPEG     2DBA     17     13     12

          SIPEG     2DBA     18     12     12

          SIPEG     2DBA     19     12     12

          SIPEG     2DBA     20     12     12

          SIPEG     2DBA     21     12     12

          SIPEG     2DBA     22     13     13

          SIPEG     2DBA     23     13     13

          SIPEG     2DBA     24     13     13

          SIPEG     2DBA     25     16     16

          SIPEG     2DBA     26     16     16

          SIPEG     2DBA     27     16     16

          SIPEG     2DBA     28     16     16

          SIPEG     2DBA     29     11     11

          SIPEG     2DBA     30     11     11

          SIPEG     2DBA     31     11     11

           

            /font[/quote]Any thoughts will be appreciated, because I have no idea.  smile.gif[/img] 

           

          Regards

          Rolf

          • Horizontal / Vertical
            Bruce _

            Rolf

             

            Do you have version 7? It has multi-columns that should make short work of this. Set up each day as a column.

             

            If you do not have ver 7, it will be harder. Set up to trap the entire block of data & manully name everything (like day 1 sales, day1 all, etc...)

             

            Good luck

            • Horizontal / Vertical
              Bruce _

              Rolf

               

              Do you have version 7? It has multi-columns that should make short work of this. Set up each day as a column.

               

              If you do not have ver 7, it will be harder. Set up to trap the entire block of data & manully name everything (like day 1 sales, day1 all, etc...)

               

              Good luck

              • Horizontal / Vertical

                Hi Bruce,

                 

                i have V6.1.    

                 

                Regards

                Rolf

                • Horizontal / Vertical

                  Hi Bruce,

                   

                  i have V6.1.    

                   

                  Regards

                  Rolf

                  • Horizontal / Vertical
                    Grant Perkins

                    Rolf,

                     

                    Have you managed to solve your problem with this?

                     

                    Bruce is correct although I don't think version 7 would be a complete answer here because you have too many columns to extract in a single extraction.

                     

                    If your report always starts with day 1 of the month then simply map all of the fields.

                     

                    If it does not OR the column width is variable you could consider extracting every required line as a complete field and then using functions with calculated fields to break the line up into the required fields.

                     

                    That does mean some work to create the model but once finished the benefit of re-usability (if you are likely to run this analysis more than once)is high.

                     

                    Grant

                     

                     

                    Originally posted by starpower:

                    Hi all,

                     

                    is somebody here to give me a kick to start from here:

                     

                    Any thoughts will be appreciated, because I have no idea.   smile.gif[/img]  

                     

                    Regards

                    Rolf /b[/quote]

                    • Horizontal / Vertical
                      Grant Perkins

                      Rolf,

                       

                      Have you managed to solve your problem with this?

                       

                      Bruce is correct although I don't think version 7 would be a complete answer here because you have too many columns to extract in a single extraction.

                       

                      If your report always starts with day 1 of the month then simply map all of the fields.

                       

                      If it does not OR the column width is variable you could consider extracting every required line as a complete field and then using functions with calculated fields to break the line up into the required fields.

                       

                      That does mean some work to create the model but once finished the benefit of re-usability (if you are likely to run this analysis more than once)is high.

                       

                      Grant

                       

                       

                      Originally posted by starpower:

                      Hi all,

                       

                      is somebody here to give me a kick to start from here:

                       

                      Any thoughts will be appreciated, because I have no idea.   smile.gif[/img]  

                       

                      Regards

                      Rolf /b[/quote]