topic Re: How to remove both two duplicates data? in Application Development and Automation Discussions

How to remove both two duplicates data?

Former Member — Fri, 20 Jan 2012 17:02:15 GMT

Hi There,

Is anyone knows how to remove both duplicate data? As far as i know is DELETE ADJACENT DUPLICATE, but it is use to remove one of it. but how to remove both?

Please help.

Thanks

Re: How to remove both two duplicates data?

Former Member — Fri, 20 Jan 2012 17:17:57 GMT

You'll have to write some custom code for that.

Rob

Re: How to remove both two duplicates data?

madhu_vadlamani — Fri, 20 Jan 2012 17:18:57 GMT

HI,

First see in that report from where you are getting that data.Then you can try for deletion.

Regards,

Madhu.

Re: How to remove both two duplicates data?

Former Member — Fri, 20 Jan 2012 18:05:34 GMT


itab2[] = itab1[].

loop at itab1 into wa_itab1.
read table itab2 with key itab2key = wa_itab1-itab1key.
count = sy-tabix.
delete from itab2 index count.
read table itab2 with key itab2key = wa_itab1-itab1key.
if sy-subrc = 0.
delete from itab1 where itab1key =  wa_itab1-itab1key.
endif.
clear wa_itab1.
endloop.

refresh itab2.

the above code should do what you want.

Edited by: aashrith on Jan 20, 2012 7:06 PM

Re: How to remove both two duplicates data?

surajarafath — Fri, 20 Jan 2012 18:21:49 GMT

if DELETE ADJACENT DUPLICATES delete one duplicate.. why cant you call it twice then.. or DO..ENd. for table line times..

will tht work?

Re: How to remove both two duplicates data?

Former Member — Fri, 20 Jan 2012 18:23:05 GMT


if DELETE ADJACENT DUPLICATES delete one duplicate.. why cant you call it twice then..

since when

Re: How to remove both two duplicates data?

Former Member — Fri, 20 Jan 2012 18:48:01 GMT


if DELETE ADJACENT DUPLICATES delete one duplicate.. why cant you call it twice then.. or DO..ENd. for table line times..
> will tht work?

There appears to be a misunderstanding.

DELETE ADJACENT DUPLICATES

will delete all duplicates, but not the original. The OP wants the original removed as well.

Rob

Re: How to remove both two duplicates data?

Former Member — Fri, 20 Jan 2012 20:20:58 GMT

As I understand your requirement if any record is occuring more than once , you wish to remove the record (with key) completly from the internal table.

While processing the internal table check for record occurences. If its only 1, then move it to your final internal table.

DELETE ADJACENT DUPLICATES will hold all unique records.

Regards

Raj

Re: How to remove both two duplicates data?

Former Member — Fri, 20 Jan 2012 22:48:09 GMT

Hi,

U can use the below code.

loop at it_xyz into wa_xyz.

data : wa_xyz1 type it_xyz.

if wa_xyz1 = wa_xyz.

delete it_xyz where abc = wa_xyz-abc.

clear wa_xyz1.

else.

wa_xyz1 = wa_xyz.

endif.

endloop.

Give me your hand if it was helpful.

Thanks

Prashanth

Edited by: Thomas Zloch on Jan 20, 2012 11:49 PM

Re: How to remove both two duplicates data?

surajarafath — Sat, 21 Jan 2012 04:26:38 GMT

Thanks Rob.

Sorry it's my mistake . I understand. I just over thought.

If you want to delete record which appearing twice or more, then I propose one logic for that.

Declare an another internal table with all the fields same as in ur original internal table and include one more integer variable(say count).

Wa_itab2-count = 1.
Loop at itab1 into wa_itab1.
Move-corresponding wa_itab1 to wa_itab2.
Collect wa_itab2 into itab2.
End loop.

Now loop again to delete,
Loop itab2 into wa_itab2 where count gt 1.
Delete...
End loop.

-count will represents no of time record exists