topic Re: REDUNDANT DATA in Application Development and Automation Discussions

REDUNDANT DATA

Former Member — Sat, 26 May 2007 11:09:51 GMT

Hi everyone,

My output for a report is similar as follows:-

F1 F2 F3 F4 F5

255 us 2345 weerr a

255 us 3455 dasrr a

255 us 5574 rrrerr a

255 us 4145 rewre a

What is the statement that exactly removes the redundant data ?

Thanks and Regards

Srikanth.M

Re: REDUNDANT DATA

Former Member — Sat, 26 May 2007 11:19:52 GMT

use

sort itab by f1 f2.

delete adjacent duplicates from itab comparing f1.

or delete adjacent duplicates from itab comparing f1 f2.

regards

shiba dutta

Re: REDUNDANT DATA

amit_khare — Sat, 26 May 2007 11:20:19 GMT

sort ITAB.

DELETE ADJACENT DUPLICATES FROM <ITAB>.

Regards,

Amit

Reward all helpful replies.

Re: REDUNDANT DATA

Former Member — Sat, 26 May 2007 14:36:49 GMT

hi Srikanth,

SORT gt_itab BY field1 field2 field5 .
DELETE ADJACENT DUPLICATES FROM gt_itab
       COMPARING field1 field2 field5 .

Regards,

Santosh

Re: REDUNDANT DATA

Former Member — Sat, 26 May 2007 14:42:41 GMT

Hi Srikanth,

DELETE ADJACENT DUPLICATES will help to you to remove redundant(duplicate) entries from an internal table. SORT the internal table with the fields which you want to delete redundat entries.

SORT ITAB BY F1 F2 F5.

DELETE ADJACENT DUPLICATES FROM ITAB

COMPARING F1 F2 F5.

Thanks,

Vinay

Re: REDUNDANT DATA

Former Member — Sat, 26 May 2007 16:08:24 GMT

It depends on what do you mean by redundant. If you are saying it is redundant even if all other columns except column F1 have different values, then you can use the DELETE ADJACENT DUPLICATES FROM itab command.

But before you do that, please check if that is what you want because, what if you actually need all of them since other values are different, what if you want the second one, not the first one. These are the questions you have to ask before deleting the entries just based on a common value of one field.