Problem in eliminating duplicates

[Former Member]

hi EXPERT

i want to take off the duplicates

eg

Emp Name

BALAJI

BALAJI

Bala

nela

anbu

MUMBAI

R

R

Amman

Amman

i have used

1. SORT it_final.

DELETE ADJACENT DUPLICATES FROM it_final.

and

2. select distict

-

---

but i dont find any change

it appears with duplicates

...

CAN YOU PLS HELP ME OUT

THANX IN ADVANCE.\

RACHEL

[GauthamV]

hi,

use this.

DELETE ADJACENT DUPLICATES FROM it_final COMPARING pernr.

[former_member223537]

SORT it_final by emp_name.
DELETE ADJACENT DUPLICATES FROM it_final comparing emp_name.

[Former Member]

Hi,

Check this thread,

http://www.geekinterview.com/question_details/1495

Regards

Guru

[bpawanchand]

Hi

DATA :

BEGIN OF fs_name,

empnam TYPE string,

END OF fs_name.

DATA :

t_name LIKE STANDARD TABLE OF fs_name.

CLEAR fs_name.

fs_name-empnam = 'XYZ'.

APPEND fs_name TO t_name.

CLEAR fs_name.

fs_name-empnam = 'XYZ'.

APPEND fs_name TO t_name.

CLEAR fs_name.

fs_name-empnam = 'ABC'.

APPEND fs_name TO t_name.

CLEAR fs_name.

fs_name-empnam = 'ABC'.

APPEND fs_name TO t_name.

CLEAR fs_name.

fs_name-empnam = 'XYZ'.

APPEND fs_name TO t_name.

CLEAR fs_name.

fs_name-empnam = 'XYZ'.

APPEND fs_name TO t_name.

SORT t_name.

LOOP AT t_name INTO fs_name.

WRITE :

/ fs_name-empnam.

ENDLOOP.

DELETE ADJACENT DUPLICATES FROM t_name.

skip 5.

LOOP AT t_name INTO fs_name.

WRITE :

/ fs_name-empnam.

ENDLOOP.

Regards

Pavan

[Former Member]

Hi Rachel,

What you are doing is right! But try to mention the Field name while sorting and also use the Comparing option in your DELETE Adjacent ...statement. So, now ur statements would be like the one below :

Sort IT_FINAL by empname.

Delete adjacent duplicates from it_final comparing empname.

This will definitely solve.

Regards,

Swapna.

[Former Member]

Hi Friend,

First you need to sort the table using emp_name and then use DELETE ADJACENT DUPLICATES.

Try the following:

SORT it_final by emp_name.

DELETE ADJACENT DUPLICATES FROM it_final COMPARING emp_name.

Regards,

Chandra Sekhar

[Former Member]

Hi,

Use the code below.

sort it_final in ascending by emp_name.

delete adjacent duplicates from it_final comparing emp_name

[Former Member]

thanx for all