4 Replies Latest reply: May 15, 2014 10:14 AM by atmmamo _ RSS

    Redundant data is carrying from one record to another

    atmmamo _

      Hello all,

       

      I have a txt report I am scraping and am having an issue.  I have records with varying rows of data.  My detail record is the last row of data.  This is always fixed and picks up correctly.  I now append multiple lines to this detail record. 

       

      Append 1 - name line 1

      Append 2 - name line 2

      Append 3 = name line 3

      Append 4 = name line 4

       

      And detail is static and pulling ok.

       

      Now, record 1 has detail + append 1 + append 2 + append 3 + append 4

      record 2 has detail + append 1 + append 2.

       

      When I look at the table, it is appending the append 3 and append 4 from record 1 to record 2.  is there a way for Monarch to understand  thaqt record 2 only needs append 1 attached to it???

       

       

       

      100         TEST BANK                                    LOAN ACCOUNTING      NAME/ADDRESS CHANGE       R-2000-001-001 10-01-12   PAGE      1

       

        ACCT NO      BEFORE CHANGE                               AFTER CHANGE                               KEYWORD  N/A SGMNT #   DATE

      00001234560   JOE SMITH                                   JOE SMITH                                  NALNE1       1       10-01-12

                     RALPH B SMITH JR                            RALPH B SMITH JR                           NALNE2

                     1900 ANYTIME DR                             2 SHIRLEY ST                               NALNE3

                     BOSTON MA 98023                             BRONX NY 03904                             NALNE4

                TRAN SRCE CODE     999  TRAN CNTL CODE    0000000

       

      00000654321   RONNIE HAMILTON                             RONNIE HAMILTON SR                         NALNE1       1       10-01-12

                     1 BLUEBERRY DR                              1 BLUEBERRY DR                             NALNE2

                     BANGOR ME 06000                             BROOKLYN NY 01234                          NALNE3

                TRAN SRCE CODE     999  TRAN CNTL CODE    0000000

       

      01000096385   BOBS LANDSCAPING                            BOBS LANDSCAPING                           NALNE1       1       10-01-12

                     1 PARK PLACE                                1 BOARDWALK DR                             NALNE2

                     HOBOKEN NJ 02150                            LAKE PLACID NY 12369                       NALNE3

                TRAN SRCE CODE     999  TRAN CNTL CODE    0000000

       

      00000007418   0000000000                                  1238675309                                 HMPHON       1       10-01-12

                TRAN SRCE CODE     999  TRAN CNTL CODE    0000000

       

      00001111111   SAM ADAMS LLC                               SAM ADAMS LLC                              NALNE1       1       10-01-12

                     123 42ND ST                                 321 52ND ST                                NALNE2

                     NEW YORK NY 12345                           NEW YORK NY 12345                          NALNE3

                TRAN SRCE CODE     999  TRAN CNTL CODE    0000000

       

      /CODE

        • Redundant data is carrying from one record to another
          Olly Bond

          Hello attmamo and welcome,

           

          Yes, just edit the properties of the Append templates so that they are set to be Cleared By the next instance of the Detail template, and you should be fine. This feature was introduced in v10.

           

          Best wishes,

           

          Olly

          • Redundant data is carrying from one record to another
            atmmamo _

            ge       r-200          00001234560     joe smith                 joe smith     nalne1     1     2012-10-01     ralph b smith jr     ralph b smith jr     nalne2     1900 anytime dr     2 shirley st     nalne3     boston ma 98023     bronx ny 03904     nalne4                    tran srce code     999     tran cntl code    0000000

            ge       r-200          00000654321     ronnie hamilton     ronnie hamilton sr     nalne1     1     2012-10-01     1 blueberry dr     1 blueberry dr     nalne2     bangor me 06000     brooklyn ny 01234     nalne3     boston ma 98023     bronx ny 03904     nalne4                    tran srce code     999     tran cntl code    0000000

            ge       r-200          01000096385     bobs landscaping     bobs landscaping     nalne1     1     2012-10-01     1 park place     1 boardwalk dr     nalne2     hoboken nj 02150     lake placid ny 12369    nalne3     boston ma 98023     bronx ny 03904     nalne4                    tran srce code     999     tran cntl code    0000000

            ge       r-200          00001111111     sam adams llc     sam adams llc     nalne1     1     2012-10-01     123 42nd st     321 52nd st     nalne2     new york ny 12345     new york ny 12345     nalne3     boston ma 98023     bronx ny 03904     nalne4                    tran srce code     999     tran cntl code    0000000

            /code