topic Re: deleting duplicate values from internal table in Application Development and Automation Discussions

deleting duplicate values from internal table

Former Member — Fri, 18 Aug 2006 11:31:21 GMT

hi experts,

i have fetched some values into internal table

along with these values some duplicate values are also coming and i want to delete them

how can i do this

i have used the code 'delete adjecent dulicate values'

still the problem is not solved

guide me

regards

siri

Former Member — Fri, 18 Aug 2006 11:32:36 GMT

You have to use SORT ITAB BY FIELDS

before calling the DELETE ADJACENT DUPLICATES.

Chers

suresh_datti — Fri, 18 Aug 2006 11:33:09 GMT

you have to use


SORT ITAB.
DELETE ADJACENT DUPLICATES FROM ITAB.

Press F1 on DELETE and examine the option of COMPARING when deleteing adjacent duplicates from an itab.

~Suresh

Former Member — Fri, 18 Aug 2006 11:33:56 GMT

I hope you are sorting the internal table before the delete statement ...else you can also try the variation for delete comparing fields f1...

Former Member — Fri, 18 Aug 2006 12:03:09 GMT

Hi,

Use this

sort <internal table> by <field>.

Delete adjacent duplicate values from itab comparing <field1> <field2>

Delete adjacent duplicate values from itab comparing all fields.

regards,

Pavan.

Former Member — Fri, 18 Aug 2006 12:13:47 GMT

thankx