3 Replies Latest reply: May 15, 2014 10:02 AM by Grant Perkins RSS

    Complexity of trapping

    henryiriawan _

      Howdy all!

       

      I want to know if we can trap this information below using monarch.

       

      Sample data:

       

      RUN DATE 07/07/08  10:13:11          D.D.A.  TRANSACTION JOURNAL      ACCR:  07/07/2008 POST:  07/07/2008 BANK #:  012345   PAGE  001

       

      0000001 020 John Doe             123  10      123.56

        ALT#-        0001

      0123456 020 BEVERLY Hills              1       70.70   1775  10      849.95        678        7.00        678        3.00

      3056789 000 LINDA HILLS          324  56      454.76  40467  12       14.23  90231  12       51.59  23915  12       36.75

                          34567  12      762.52  85611  12      180.04  89897  12      172.98  40664  12      342.00

                           4567  12      532.78

      /codeThe data above should be shown below:

       

      0000001 020 John Doe            123 10      123.56

      0123456 020 BEVERLY Hills            1       70.70  

      0123456 020 BEVERLY Hills     1775  10      849.95

      0123456 020 BEVERLY Hills      678            7.00      

      0123456 020 BEVERLY Hills      678            3.00  

      3056789 000 LINDA HILLS        324  56      454.76

      3056789 000 LINDA HILLS      40467  12       14.23

      3056789 000 LINDA HILLS      90231  12       51.59 

      3056789 000 LINDA HILLS      23915  12       36.75           

      3056789 000 LINDA HILLS      34567  12      762.52 

      3056789 000 LINDA HILLS      85611  12      180.04 

      3056789 000 LINDA HILLS      89897  12      172.98 

      3056789 000 LINDA HILLS      40664  12      342.00

      3056789 000 LINDA HILLS       4567  12      532.78

      /codeIs it possible in Monarch to do like shown above? All comments and suggestions are appreciated.

       

      Thank you in advance for the help.

       

      Henry

        • Complexity of trapping
          Grant Perkins

          Assuming the last two lines of the sample are not shifted left on the real report I think you need Multi-Column Region functionality.

           

          4 columns. 3 fields per column.

           

          The three fields are

           

          34567  12      762.52

           

           

          which pattern repeats 4 times.

           

          The fields to the left of the columns can be dealt with in an append template.

           

          You may wish to sort the table and re-order the fields to get the output just as you posted.

           

          Try it and see how far you get. There are extended options of you find it does not quite work as you need it to work.

           

          HTH.

           

           

          Grant

            • Complexity of trapping
              henryiriawan _

              Hi Grant,

               

              Unfortunately, the last two lines for Linda Hills are shift to the left. I tried the Multi-Column Region, however, it would not capture the same information since the last two lines are shift to the left. So, is this possible?

               

              Thank you.

                • Complexity of trapping
                  Grant Perkins

                  Hi Grant,

                   

                  Unfortunately, the last two lines for Linda Hills are shift to the left. /quote

                   

                  Henry,

                   

                  Good grief.

                   

                  How does anyone manage to read the original report? Perhaps they don't ...

                   

                  Just Linda Hills or any record with multiple rows per person?

                   

                  If there are multiple lines shifted are they always shifted by the same amount?

                   

                  There are several ways to approach this but which is optimal may depend on how consistently this inconsistency has been programmed.

                   

                  The simplest approach may be to re-create the report correcting the left shift using Monarch and exporting the result. You could then run the new version through another Monarch model applying the MCR feature.

                   

                  It may be possible to use a variant method of applying the MCR functionality (double VooDoo technique) to arrive at the same end point all within one model. It all depends on how much of a challenge you want to undertake. (And the answers to the question of course ...)

                   

                   

                  Grant