topic Re: Problem in eliminating duplicates in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447215#M1054711 <HTML><HEAD></HEAD><BODY><P>Hi Rachel,</P><P></P><P>What you are doing is right! But try to mention the <STRONG>Field name</STRONG> while sorting and also use the <STRONG>Comparing</STRONG> option in your <STRONG>DELETE Adjacent ...statement</STRONG>. So, now ur statements would be like the one below :</P><P></P><PRE><CODE>Sort IT_FINAL by empname. Delete adjacent duplicates from it_final comparing empname.</CODE></PRE><P></P><P>This will definitely solve.</P><P></P><P>Regards,</P><P>Swapna.</P></BODY></HTML> Mon, 08 Sep 2008 05:44:52 GMT Former Member 2008-09-08T05:44:52Z Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447210#M1054706 <HTML><HEAD></HEAD><BODY><P>hi EXPERT</P><P>i want to take off the duplicates </P><P></P><P>eg</P><P></P><P>Emp Name </P><P></P><P>BALAJI </P><P>BALAJI </P><P>Bala </P><P>nela </P><P>anbu </P><P>MUMBAI </P><P>R </P><P>R </P><P>Amman </P><P>Amman </P><P>i have used</P><P></P><P>1. SORT it_final.</P><P>DELETE ADJACENT DUPLICATES FROM it_final.</P><P></P><P>and</P><P>2. select distict</P><P></P><P></P><P>-</P><HR originaltext="-------------------------------------------------------------------------------" /><P></P><P>but i dont find any change</P><P></P><P>it appears with duplicates</P><P>...</P><P>CAN YOU PLS HELP ME OUT</P><P>THANX IN ADVANCE.\</P><P></P><P>RACHEL</P></BODY></HTML> Mon, 08 Sep 2008 05:26:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447210#M1054706 Former Member 2008-09-08T05:26:28Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447211#M1054707 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>use this.</P><P></P><P> DELETE ADJACENT DUPLICATES FROM it_final COMPARING pernr.</P></BODY></HTML> Mon, 08 Sep 2008 05:28:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447211#M1054707 GauthamV 2008-09-08T05:28:02Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447212#M1054708 <HTML><HEAD></HEAD><BODY><PRE><CODE>SORT it_final by emp_name. DELETE ADJACENT DUPLICATES FROM it_final comparing emp_name.</CODE></PRE></BODY></HTML> Mon, 08 Sep 2008 05:29:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447212#M1054708 Former Member 2008-09-08T05:29:00Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447213#M1054709 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this thread,</P><P></P><P><A href="http://www.geekinterview.com/question_details/1495" target="test_blank">http://www.geekinterview.com/question_details/1495</A></P><P></P><P>Regards</P><P>Guru</P></BODY></HTML> Mon, 08 Sep 2008 05:32:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447213#M1054709 Former Member 2008-09-08T05:32:09Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447214#M1054710 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>DATA :</P><P> BEGIN OF fs_name,</P><P> empnam TYPE string,</P><P> END OF fs_name.</P><P></P><P>DATA :</P><P> t_name LIKE STANDARD TABLE OF fs_name.</P><P></P><P></P><P>CLEAR fs_name.</P><P>fs_name-empnam = 'XYZ'.</P><P>APPEND fs_name TO t_name.</P><P></P><P>CLEAR fs_name.</P><P>fs_name-empnam = 'XYZ'.</P><P>APPEND fs_name TO t_name.</P><P></P><P>CLEAR fs_name.</P><P>fs_name-empnam = 'ABC'.</P><P>APPEND fs_name TO t_name.</P><P></P><P>CLEAR fs_name.</P><P>fs_name-empnam = 'ABC'.</P><P>APPEND fs_name TO t_name.</P><P></P><P>CLEAR fs_name.</P><P>fs_name-empnam = 'XYZ'.</P><P>APPEND fs_name TO t_name.</P><P></P><P>CLEAR fs_name.</P><P>fs_name-empnam = 'XYZ'.</P><P>APPEND fs_name TO t_name.</P><P></P><P></P><P>SORT t_name.</P><P></P><P></P><P></P><P>LOOP AT t_name INTO fs_name.</P><P></P><P> WRITE :</P><P> / fs_name-empnam.</P><P></P><P>ENDLOOP.</P><P></P><PRE><CODE>DELETE ADJACENT DUPLICATES FROM t_name.</CODE></PRE><P></P><P>skip 5.</P><P>LOOP AT t_name INTO fs_name.</P><P></P><P> WRITE :</P><P> / fs_name-empnam.</P><P></P><P>ENDLOOP.</P><P></P><P></P><P>Regards</P><P>Pavan</P></BODY></HTML> Mon, 08 Sep 2008 05:32:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447214#M1054710 bpawanchand 2008-09-08T05:32:50Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447215#M1054711 <HTML><HEAD></HEAD><BODY><P>Hi Rachel,</P><P></P><P>What you are doing is right! But try to mention the <STRONG>Field name</STRONG> while sorting and also use the <STRONG>Comparing</STRONG> option in your <STRONG>DELETE Adjacent ...statement</STRONG>. So, now ur statements would be like the one below :</P><P></P><PRE><CODE>Sort IT_FINAL by empname. Delete adjacent duplicates from it_final comparing empname.</CODE></PRE><P></P><P>This will definitely solve.</P><P></P><P>Regards,</P><P>Swapna.</P></BODY></HTML> Mon, 08 Sep 2008 05:44:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447215#M1054711 Former Member 2008-09-08T05:44:52Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447216#M1054712 <HTML><HEAD></HEAD><BODY><P>Hi Friend,</P><P></P><P>First you need to sort the table using <STRONG>emp_name</STRONG> and then use DELETE ADJACENT DUPLICATES.</P><P></P><P></P><P>Try the following:</P><P></P><PRE><CODE>SORT it_final by emp_name. DELETE ADJACENT DUPLICATES FROM it_final COMPARING emp_name.</CODE></PRE><P></P><P></P><P>Regards,</P><P>Chandra Sekhar</P></BODY></HTML> Mon, 08 Sep 2008 05:45:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447216#M1054712 Former Member 2008-09-08T05:45:04Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447217#M1054713 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> Use the code below.</P><P></P><P>sort it_final in ascending by emp_name.</P><P></P><P>delete adjacent duplicates from it_final comparing emp_name</P></BODY></HTML> Mon, 08 Sep 2008 05:57:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447217#M1054713 Former Member 2008-09-08T05:57:25Z Re: Problem in eliminating duplicates https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447218#M1054714 <HTML><HEAD></HEAD><BODY><P>thanx for all</P></BODY></HTML> Mon, 08 Sep 2008 05:58:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-eliminating-duplicates/m-p/4447218#M1054714 Former Member 2008-09-08T05:58:32Z