topic Re: delete adjacent duplicates in Application Development and Automation Discussions

delete adjacent duplicates

Former Member — Thu, 25 Oct 2007 07:34:17 GMT

hii the data in internal table is like this

i want to delete duplicate record if exists co mparing all fields

BUT WHEN I AMD DOING

delete adjacent duplicates from it_dup_record comparing all fields.

ITS NOT DELETING THE DUPLICATE RECORD AS IN BOLD IT IS STILL THERE IN THE INTERNAL TABLE WHY PLS SUGGEST?

ALL THREE FIELDS ARE PRIMARY KEY BUT I DONT THING THAT HAS TO DO ANYTHING WITH INTERNAL TABLE I JUST WANT TO DELTE THE DUPLICATE RECORDS IF ANY EXAXTLY SIMILAR AND SAME IE ALL THREE FIELDS

CUSTEOMER NAME AND EMAIL IS SAME FOR THE TWO RECORDS THEN I WANT TO DELTE

PLS SUGGEST ASAP

|0000000011|Cypress Semiconduct<12 |0000000011|Cypress Semiconduct<12345dfdfdfdfd

<b> |0000000011|Cypress Semiconduct<13

|0000000011|Cypress Semiconduct<13 </b>

|0000000011|Cypress Semiconduct<13456dfdfddfdfdfdfd

Re: delete adjacent duplicates

Former Member — Thu, 25 Oct 2007 07:40:04 GMT

HI,

Try like this..

Sort the table first ...

and then write delete statement without any comparision ..

Regards,

Omkar.

Re: delete adjacent duplicates

Former Member — Thu, 25 Oct 2007 07:40:57 GMT

Hi Nishant.,.,

delete adjacent duplicates from it_dup_record comparing all fields.

dont give comparing all fields

Before that

SORT it_dup_record.(Based on Primery Key.,.,in ur case 3 are there right.,)

DELETE ADJACENT DUPLICATES FROM it_dup_record .

it will solve ur problem

Deb

Message was edited by:

Debasish Das

Re: delete adjacent duplicates

gopi_narendra — Thu, 25 Oct 2007 07:41:52 GMT

Sort the internal table first with the 3 fields which you want.

Then use the Delete Adjacenet Duplicates statement to delete the duplicate entires in that internal table.

Hope this sovles

Regards

Gopi

Re: delete adjacent duplicates

Former Member — Thu, 25 Oct 2007 09:49:02 GMT

Hi Arora,

Try this.

sort it_dup_record by customer name email.

delete adjacent duplicates from it_dup_record.

sort it_dup_record by customer name email.

delete adjacent duplicates from it_dup_record comparing customer name email.

Reward if useful.

Regards,

Chitra

Re: delete adjacent duplicates

Former Member — Mon, 29 Oct 2007 03:06:15 GMT

hi all

i ahve found the solution

it should be delete adjacent duplicate by all primary key name ie pk1 pk2 pk3

comparing all fields somtimes dont delete the records

arora

Re: delete adjacent duplicates

Former Member — Mon, 05 Nov 2007 09:30:00 GMT

answered