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

    trouble trapping with duplicate detail lines

    D Hart

      I have a report file, a snippet of which follows. My problem is that the row that identifies the employee ID (BORCA) the name (BORGES, CATINA) and SSN (243-99-9999) is duplicated for every employee. How do I set the trap so it ignores the 2nd occurrence of the emplyee id/name/ssn when they are formatted identically? Sample from file:

       

      EMPLOYEE PROFILE                                               11/20/2006

           CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459                                              Page     1

       

              -


       

               BORCA  BORGES, CATINA                                    243-99-9999

                         710 N. _______ AVE           FEMALE                                                                      

      EEO CODE     2                          CLOCK #                             

                         (999) 999-9999                BIRTH DATE   01/09/1900                 AVG HRS            80.00            

                                                       HIRE DATE    01/09/2000                 TERM CODE                           

                                                       TERM DATE      /  /                     POSITION     CNA                    

            

                PROFLIC      01/31/2007           4         0.00           4               4  

       

           __________________________________________________________________________

       

           PAYCHEX INC.                  PHONE  (336)841-5600     FAX         (336)841-6210

       

       

           EMPLOYEE PROFILE                                               11/20/2006

           CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459                                              Page     2

       

              -


       

               BORCA  BORGES, CATINA                                    243-99-9999

       

              -


      SALARY/JOB HISTORY -


       

                  DATE        DIV   BRCH   DEPT DESCRIPTION CHANGE              SALARY   HOURLY

       

                01/20/2006     01     04      5 NEW HIRE    CNA                   0.00     8.00

                05/12/2006     01     04      5 RATE                              0.00    10.00

                07/07/2006     01     04      5 RATE                              0.00    10.40

        • trouble trapping with duplicate detail lines
          D Hart

          I have a report file, a snippet of which follows. My problem is that the row that identifies the employee ID (BORCA) the name (BORGES, CATINA) and SSN (243-99-9999) is duplicated for every employee. How do I set the trap so it ignores the 2nd occurrence of the emplyee id/name/ssn when they are formatted identically? Sample from file:

           

          EMPLOYEE PROFILE                                               11/20/2006

               CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459                                              Page     1

           

                  -


           

                   BORCA  BORGES, CATINA                                    243-99-9999

                             710 N. _______ AVE           FEMALE                                                                      

          EEO CODE     2                          CLOCK #                             

                             (999) 999-9999                BIRTH DATE   01/09/1900                 AVG HRS            80.00            

                                                           HIRE DATE    01/09/2000                 TERM CODE                           

                                                           TERM DATE      /  /                     POSITION     CNA                    

                

                    PROFLIC      01/31/2007           4         0.00           4               4  

           

               __________________________________________________________________________

           

               PAYCHEX INC.                  PHONE  (336)841-5600     FAX         (336)841-6210

           

           

               EMPLOYEE PROFILE                                               11/20/2006

               CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459                                              Page     2

           

                  -


           

                   BORCA  BORGES, CATINA                                    243-99-9999

           

                  -


          SALARY/JOB HISTORY -


           

                      DATE        DIV   BRCH   DEPT DESCRIPTION CHANGE              SALARY   HOURLY

           

                    01/20/2006     01     04      5 NEW HIRE    CNA                   0.00     8.00

                    05/12/2006     01     04      5 RATE                              0.00    10.00

                    07/07/2006     01     04      5 RATE                              0.00    10.40

          • trouble trapping with duplicate detail lines
            Grant Perkins

            /size[quote]code:[/size]EMPLOYEE PROFILE 11/20/2006

            CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459 Page 1

             

            -


             

            BORCA BORGES, CATINA 243-99-9999

            710 N. _______ AVE FEMALE

            EEO CODE 2 CLOCK #

            (999) 999-9999 BIRTH DATE 01/09/1900 AVG HRS 80.00

            HIRE DATE 01/09/2000 TERM CODE

            TERM DATE / / POSITION CNA

             

            PROFLIC 01/31/2007 4 0.00 4 4

             

            __________________________________________________________________________

             

            PAYCHEX INC. PHONE (336)841-5600 FAX (336)841-6210

             

             

            EMPLOYEE PROFILE 11/20/2006

            CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459 Page 2

             

            -


             

            BORCA BORGES, CATINA 243-99-9999

             

            -


            SALARY/JOB HISTORY -


             

            DATE DIV BRCH DEPT DESCRIPTION CHANGE SALARY HOURLY

             

            01/20/2006 01 04 5 NEW HIRE CNA 0.00 8.00

            05/12/2006 01 04 5 RATE 0.00 10.00

            07/07/2006 01 04 5 RATE 0.00 10.40 /QUOTEHi,

             

            A question.

             

            What lines of the report do you think of as the record you are extracting? Is the information for one individual spread over 2 pages and you need both pages or do you only need one of the 'pages'?

             

            If you only needed page one I would think trapping on the name and SSN would be OK and then just filter whatever was captured for the unwanted page using some sort of consistent identifier to perform the filter.

             

            If that would not give what you want the next option would be to seek to set the trap on a different line so that only one record is created. Maybe line 3 for example if it always contains some constant text with which to trap.

             

            Your sample snippet seems to offer some opportunities but does the whole report offer the same opportunity?

             

            HTH.

             

             

            Grant

            • trouble trapping with duplicate detail lines
              Grant Perkins

              /size[quote]code:[/size]EMPLOYEE PROFILE 11/20/2006

              CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459 Page 1

               

              -


               

              BORCA BORGES, CATINA 243-99-9999

              710 N. _______ AVE FEMALE

              EEO CODE 2 CLOCK #

              (999) 999-9999 BIRTH DATE 01/09/1900 AVG HRS 80.00

              HIRE DATE 01/09/2000 TERM CODE

              TERM DATE / / POSITION CNA

               

              PROFLIC 01/31/2007 4 0.00 4 4

               

              __________________________________________________________________________

               

              PAYCHEX INC. PHONE (336)841-5600 FAX (336)841-6210

               

               

              EMPLOYEE PROFILE 11/20/2006

              CXXXXXXXXXXX HXXXXX SXXXXXXX INC - R459 Page 2

               

              -


               

              BORCA BORGES, CATINA 243-99-9999

               

              -


              SALARY/JOB HISTORY -


               

              DATE DIV BRCH DEPT DESCRIPTION CHANGE SALARY HOURLY

               

              01/20/2006 01 04 5 NEW HIRE CNA 0.00 8.00

              05/12/2006 01 04 5 RATE 0.00 10.00

              07/07/2006 01 04 5 RATE 0.00 10.40 /QUOTEHi,

               

              A question.

               

              What lines of the report do you think of as the record you are extracting? Is the information for one individual spread over 2 pages and you need both pages or do you only need one of the 'pages'?

               

              If you only needed page one I would think trapping on the name and SSN would be OK and then just filter whatever was captured for the unwanted page using some sort of consistent identifier to perform the filter.

               

              If that would not give what you want the next option would be to seek to set the trap on a different line so that only one record is created. Maybe line 3 for example if it always contains some constant text with which to trap.

               

              Your sample snippet seems to offer some opportunities but does the whole report offer the same opportunity?

               

              HTH.

               

               

              Grant