Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

deleting duplicate values from internal table

Former Member
0 Likes
827

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
763

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

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

5 REPLIES 5
Read only

Former Member
0 Likes
763

You have to use SORT ITAB BY FIELDS

before calling the DELETE ADJACENT DUPLICATES.

Chers

VJ

Read only

suresh_datti
Active Contributor
0 Likes
763

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

Read only

Former Member
0 Likes
764

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

Read only

0 Likes
763

thankx

Read only

Former Member
0 Likes
763

Hi,

Use this

sort <internal table> by <field>.

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

or

Delete adjacent duplicate values from itab comparing all fields.

regards,

Pavan.