topic Re: Delete duplicate records issue in Application Development and Automation Discussions

Delete duplicate records issue

Former Member — Thu, 27 Feb 2014 09:37:16 GMT

Dear experts,

i did one development 1 month back for send mail.

In that i fetch email id of F_cord from one table(zcoordinator) based on some condition.now they want to changes in that object.

now two new fields added in that table ven_cord and HOD, both have some mail id.

As per their requirement , i need to fetch the ven_cord mail id and HOD mail id from that same table for priviously fetched F_cord.

And I need to delete duplicate ven_cord from tha table.

So for this should i need to create another structure or any ohther ways to solve the requirement.

\Plase suggest ?

Kin Regards,

Ajit

Re: Delete duplicate records issue

atul_mohanty — Thu, 27 Feb 2014 09:44:10 GMT

Hi Ajit -

Issue is not very clear. can you share the code please ?

Regards,

Atul Mohanty

Re: Delete duplicate records issue

former_member187748 — Thu, 27 Feb 2014 09:44:36 GMT

Hi Ajit,

while selecting data from your ztable, just use delete adjacent duplicates compairing ven_cord,

whats the problem in doing the simple stuff, yes if you have created any structure then you have

to change it, and you have to add these fields in this structure too, otherwise it will give you dump on

PRD system. (Not for ven_cord field, but for new field, i.e. HOD to be added in structure)

Re: Delete duplicate records issue

Former Member — Thu, 27 Feb 2014 09:56:09 GMT

--- Where did you stored your previously fetched F_cord mail id's ? or

you have fetched the F_cord mail id's to internal table simply to use them in your further logic ?

Regards,

Govardhan Duvva.

Re: Delete duplicate records issue

Former Member — Thu, 27 Feb 2014 09:58:08 GMT

@sanjeev,

I do't have create a separate structure for fetch these two fields ?

As per you, I need to add these two new fields to that previous structure which I created for F_CORD, Wright ?

And during fetch statement I need to add these two new fields. wright ?

Then how to delete the duplicate ven_cord for the perticular F_CORD.

Please suggst ?

I can't paste the code here ?

Regards,

Ajit

Re: Delete duplicate records issue

Former Member — Thu, 27 Feb 2014 09:59:52 GMT

@duvva,

Already I have the email id of F_CORD, i need to fetch v_CORD and HOD mail ids based on F_CORD. and the ven_cord and hod mail id are present in the same table zcordiator which i mentioned before.

Re: Delete duplicate records issue

Former Member — Thu, 27 Feb 2014 10:04:52 GMT

Ajit,

On what condition are you fetching the F_CORD first ? Could you paste atleast the first select query to fetch the F_CORD ?

-- Govardhan Duuva

Re: Delete duplicate records issue

former_member187748 — Thu, 27 Feb 2014 10:05:33 GMT

Hi Ajit,

you have written "As per their requirement , i need to fetch the ven_cord mail id and HOD mail id from that same

table for priviously fetched F_cord."

If you have added both the new fields in your table (ven_cord and HOD), then you have to add both these in your structure.

See, once you have selected f_cord mail id, please tell me what is the field name in which you have

selected previously mail id. (before adding these two new fields).

Re: Delete duplicate records issue

Former Member — Thu, 27 Feb 2014 10:12:37 GMT

@sanjeev,

I have the issuing coordinator mail id in f_cord which i got priviously from zcoordinator table.

now i need to fetch two new field values for these f-cord.

Re: Delete duplicate records issue

nabheetscn — Thu, 27 Feb 2014 10:16:58 GMT

Ajit

Why dont you start coding and let us know in case of any issues.

Nabheet

Re: Delete duplicate records issue

former_member187748 — Thu, 27 Feb 2014 10:22:23 GMT

Ajit,

i was asking about the field name, as far as i concern, your scenario is something like

you have three fields in your custom table, and all these fields have same data (or any of the fields have same data).

Now you wants only unique value to be fetched from all these fields, am i right ?

Re: Delete duplicate records issue

jayanthi_jayaraman — Thu, 27 Feb 2014 10:23:03 GMT

Hi,

select the other two fields as well in the select table along with previous field which you selected f_Cord.

Once you received details in internal table, sort the table by key fields and then ven_cord.

Then use delete adjacent duplicates for the same.

Re: Delete duplicate records issue

hiriyappa_myageri — Thu, 27 Feb 2014 11:39:44 GMT

Hi,

can u plz explain ur scenario with sample data's.

Regards,

Hiriyappa