topic Re: remove duplicate rows. in Application Development and Automation Discussions

remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:49:20 GMT

Hi,

I want remove all the duplicate rows from internal table comparing all the fields. my internal table has following fields.

internal table -> it_final

partner.

industry.

is_competitor.

is_prospect.

is_consumer.

is_customer.

customer_since.

is_rented.

nielsen_id.

classific.

account_group.

I want to remove duplicates only if all the above fields have same data in a row and not a single field contains duplicate data.

Pls help

Regards,

Santosh

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:51:43 GMT

Hello,

First sort the internal table by the key fields and then delete the duplicates.

SORT IT_TAB BY PARTNER INDUSTRY and so on.
DELETE ADJACENT DUPLICATES FROM IT_ITAB COMPARING ALL FIELDS.

Regards,

Shailaja

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:52:19 GMT

Hi,

[]

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:52:51 GMT

Hi santosh,

You can use following to remove all duplicates..

DELETE ADJACENT DUPLICATES FROM it_final COMPARING ALL FIELDS.

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:52:54 GMT

Hi,


Sort <internal table>.

DELETE ADJACENT DUPLICATES FROM  internaL TALBLE NAME COMPARING ALL FIELDS

HOPE IT WILL HELP YOU

THANKS

ARUN KAYAL

Edited by: Arun Kayal on Feb 4, 2009 6:55 AM

Re: remove duplicate rows.

GauthamV — Wed, 04 Feb 2009 05:52:56 GMT

I dont think you will get any such kind of scenarios where entire

record is same.

Anyhow use this for that purpose.

delete adjacent duplicates from itab comparing all fields.

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:52:58 GMT

Hi,

Try like this....



Sort <internal table>.
delete adjacent duplicates from <internaltable> comparing all fields.

Hope it will helps

Re: remove duplicate rows.

former_member222860 — Wed, 04 Feb 2009 05:53:09 GMT

Did U tried with

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING ALL FIELDS

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:53:20 GMT

Hi Santosh,

There are many similar thread for the same issue in SCN.

Please search.

READ HELP ON DELETE ADJACENT DUPLICATES FROM itab.

Regards,

Nitin.

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:53:27 GMT

Hi santhosh,

use

DELETE ADJACENT DUPLICATES FROM it_final COMPARING <field_name>

Re: remove duplicate rows.

Former Member — Wed, 04 Feb 2009 05:55:24 GMT

DELETE ADJACENT DUPLICATES FROM itab comparing all fields

Re: remove duplicate rows.

I355602 — Wed, 04 Feb 2009 05:56:17 GMT

Hi,

Use:-

To delete comparing all fields.


sort itab by field1 field2 field3. "and so on for using all fields
delete adjacent duplicates from itab comparing all fields.

To delete comparing only one field


sort itab by field1.
delete adjacent duplicates from itab comparing field1.

Hope this solves your problem.

Thanks & Regards,

Tarun Gambhir

Re: remove duplicate rows.

faisalatsap — Wed, 04 Feb 2009 06:12:43 GMT

Hi,

Test the following Sample Code hope will solve out your problem,

TYPES: BEGIN OF t_test,
  s_number TYPE i,
  name1(10),
  name2(10),
END OF t_test.

data: it_test TYPE STANDARD TABLE OF t_test WITH HEADER LINE.

it_test-s_number = 1.
it_test-name1 = 'AAA'.
it_test-name2 = 'AAA'.
append it_test to it_test.

it_test-s_number = 2.
it_test-name1 = 'AAA'.
it_test-name2 = 'AAA'.
append it_test to it_test.

it_test-s_number = 2.
it_test-name1 = 'AAA'.
it_test-name2 = 'AAA'.
append it_test to it_test.

it_test-s_number = 3.
it_test-name1 = 'AAA'.
it_test-name2 = 'BBB'.
append it_test to it_test.

it_test-s_number = 4.
it_test-name1 = 'AAA'.
it_test-name2 = 'BBB'.
append it_test to it_test.

it_test-s_number = 5.
it_test-name1 = 'AAA'.
it_test-name2 = 'BBB'.
append it_test to it_test.

SORT it_test by s_number name1 name2.

DELETE ADJACENT DUPLICATES FROM it_test COMPARING ALL FIELDS.

Kind Regards,

Faisal

Re: remove duplicate rows.

Former Member — Thu, 05 Feb 2009 06:54:39 GMT

hi,

According to my understanding of ur requirement u want to delete duplicate rows in every field.

say records are:

A LMN XYZ

AA PQR XYZ

then these records shd be deleted as field3 has duplicate entries.

internal table -> it_final

partner.

industry.

is_competitor.

is_prospect.

is_consumer.

is_customer.

customer_since.

is_rented.

nielsen_id.

classific.

account_group.

can do the following:

data:

t_fieldname type string occurs 10 with header line.

t_fieldname = 'PARTNER'.

append t_fieldname.

likewise append all the fieldnames into t_fieldname industry is_competitor so on....

sort it_final by partner industry is_competitor is_prospect is_consumer is_customer customer_since

is_rented nielsen_id classific account_group.

loop at t_fieldname.

delete adjacent duplicates from it_final comparing t_fieldname.

endloop.

it checks each field and deletes the adj duplicate rec.

Regards,

Mdi.Deeba Najam.

Re: remove duplicate rows.

Former Member — Thu, 05 Feb 2009 07:02:10 GMT

Sort the internal table first based on the fields

and use delete adjascent command with the fields

Re: remove duplicate rows.

Former Member — Thu, 05 Feb 2009 07:03:50 GMT

Hi,

SORT IT_TAB BY partner industry is_competitor is_prospect is_consumer is_customer

customer_since is_rented nielsen_id classific account_group.

DELETE ADJACENT DUPLICATES FROM IT_ITAB COMPARING ALL FIELDS.

Regards,

Mon Magallanes

Re: remove duplicate rows.

Former Member — Thu, 05 Feb 2009 07:17:11 GMT

Hi,

You can achieve it by sorting the table with all the fields and delete adjacent duplicates .

SORT <table-name> by<field-name or mention all field names> .

DELETE adjacent duplicates FROM <table-name> comparing ALL fields.

Regards,

Rajani

Re: remove duplicate rows.

Former Member — Thu, 05 Feb 2009 07:24:01 GMT

Im blind, cant read and write properly and cant comprehend things that easily too. so im not sure if the question has been answered yet or not. so here is my answer:

I think what you need to do is SORT the internal table and then use the DELETE ADJACENT DUPLICATES statment on the internal table.

Im not really sure if this will solve your problem. You might want to wait for a few more replies to get a confirmation and then close the thread.

Please dont forget to do the needful too.

Re: remove duplicate rows.

Former Member — Thu, 05 Feb 2009 07:57:28 GMT

My vote is also for deleting adjacent duplicates from the internal table comparing the fields which should be the same, and I also want to pay less taxes and those people living under the bridge near the railway station should be given a home and a warm blanket.

Next please...

Re: remove duplicate rows.

Former Member — Thu, 05 Feb 2009 08:38:17 GMT

Hi Santosh,

If you got to remove absolutely duplicate entries from an internal table,

first sort the table and

DELETE ADJACENT FROM IT_TAB COMPARING ALL FIELDS.

But in case, you do not have to delete the entries, but to avoid duplication of display, then either give AT NEW FIELDNAME within the LOOP, or use ON CHANGE OF IT_TAB-FIELDNAME.

Thankyou,

Zahack