Delete duplicate records issue

[Former Member]

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

[atul_mohanty]

Hi Ajit -

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

Regards,

Atul Mohanty

[former_member187748]

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)

[Former Member]

@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

[former_member187748]

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).

[Former Member]

@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.

[nabheetscn]

Ajit

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

Nabheet

[former_member187748]

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 ?

[Former Member]

                                   --- 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.

[Former Member]

@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.

[Former Member]

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

[jayanthi_jayaraman]

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.

[hiriyappa_myageri]

Hi,

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

Regards,

Hiriyappa