topic Re: Finding Duplicates Records in Application Development and Automation Discussions

Finding Duplicates Records

Former Member — Wed, 03 Mar 2010 06:33:17 GMT

Hi All,

I have a scenario i got one internal table itab1 with 3 fields f1,f2,f3 and i am fetching some data from a standard table.Now i want to loop through the table itab1-f1 and see if there is any duplicate entries.How can this be done.I want some logic which is efficient.

Regards,

Ravi

Edited by: ravi r on Mar 3, 2010 7:34 AM

Re: Finding Duplicates Records

anup_deshmukh4 — Wed, 03 Mar 2010 06:42:30 GMT

Hello ravi r ,

Your can very well use contror break for the itab for itab-f1 and write the logic in same u can use CNT(itab-F1) for counting the duplicates Chek for F1 help...!

AT END.

ENDAT.

in your loop.

or the other way is Sort and Loop ...use binary search ..Use parell Cursor for effeciency...!

Edited by: Anup Deshmukh on Mar 3, 2010 7:43 AM

Re: Finding Duplicates Records

GauthamV — Wed, 03 Mar 2010 06:44:40 GMT

If you already have data in itab1 from standard table then check something like this.


Sort itab by f1.
Loop at itab.
Delete adjacent duplicates from itab comparing f1.
endloop.

Re: Finding Duplicates Records

anup_deshmukh4 — Wed, 03 Mar 2010 06:46:12 GMT

check example cnt will give you the number of duplicates count


NODES: spfli, sflight. 

FIELD-GROUPS: header, flight_info, flight_date. 

START-OF-SELECTION. 
  INSERT: spfli-carrid spfli-connid sflight-fldate 
            INTO header, 
          spfli-cityfrom spfli-cityto 
            INTO flight_info. 

GET spfli. 
  EXTRACT flight_info. 

GET sflight. 
  EXTRACT flight_date. 

END-OF-SELECTION. 
  SORT STABLE. 
  LOOP. 
    AT FIRST. 
      WRITE / 'Flight list'. 
      ULINE. 
    ENDAT. 
    AT flight_info WITH flight_date. 
      WRITE: / spfli-carrid , spfli-connid, sflight-fldate, 
               spfli-cityfrom, spfli-cityto. 
    ENDAT. 
    AT flight_date. 
      WRITE: / spfli-carrid , spfli-connid, sflight-fldate. 
    ENDAT. 
    AT LAST. 
      ULINE. 
      WRITE: cnt(spfli-carrid), 'Airlines'. 
      ULINE. 
    ENDAT. 
  ENDLOOP.

Edited by: Anup Deshmukh on Mar 3, 2010 7:46 AM

Re: Finding Duplicates Records

Former Member — Wed, 03 Mar 2010 06:47:07 GMT

Hi,

Use the following logic.

SORT itab ASCENDING BY f1.

LOOP AT itab.
MOVE SY-INDEX to indx.
indx = indx + 1.
READ itab into wa_temp with index indx.
IF itab-f1 eq wa_temp-f1.
   duplicate.
ELSE.
   process your logic.
ENDIF.
CLEAR indx.
ENDLOOP.

Regards,

Shankar.