Question Re: Duplicate Records in Technology Q&A

Duplicate Records

Former Member — Sun, 25 Feb 2007 21:01:41 GMT

HI Group,

In File to File Scenario how to avoid duplicate records

Re: Duplicate Records

MichalKrawczyk — Sun, 25 Feb 2007 21:03:54 GMT

Hi,

Don't send the same file twice

Regards,

michal

Re: Duplicate Records

Former Member — Sun, 25 Feb 2007 21:53:43 GMT

HI Michal,

If I have record whcih repeating twice in the same file how to avoid this situation

Re: Duplicate Records

Former Member — Sun, 25 Feb 2007 22:31:19 GMT

Hi swabap,

you do that inside the mapping. I would take ABAP or XSL for that reason. May be Java but not grafical. Sort the fields and loop. Remember the value of the actual field and compare with the last. If same throw away. I cant translate the programming technique very well into english, may be it is call "group step handling" or something like that.

Regards,

Udo

Re: Duplicate Records

Former Member — Mon, 26 Feb 2007 03:22:28 GMT

Hi,

You can write a script which will remove the duplicate records. Run this script in the OS command faclitiy provided in the File adapter.

Check the following link for reference...

<a href="/people/sameer.shadab/blog/2005/09/21/executing-unix-shell-script-using-operating-system-command-in-xi:///people/sameer.shadab/blog/2005/09/21/executing-unix-shell-script-using-operating-system-command-in-xi

Regards,

Akshay

Re: Duplicate Records

Former Member — Mon, 26 Feb 2007 03:28:49 GMT

you could check this in a Module and remove duplicate record inside same file.

Re: Duplicate Records

Former Member — Mon, 26 Feb 2007 04:01:10 GMT

write module processor for checking the duplicate record in file adapter.

Regards

Sreeram.G.Reddy

Re: Duplicate Records

prabhu_s2 — Mon, 26 Feb 2007 04:08:20 GMT

1. With a JAVA/ABAP mapping u can eliminate the duplicate records or

2. Write a Module for Sender CC where the duplicate records shud not be considred

in grpahical mapping , we might need to explore on how it can be worked out.....

Re: Duplicate Records

Former Member — Mon, 26 Feb 2007 04:21:10 GMT

HI,

I hope you have to write one User defined function ...

Please try

take queue function ..

Vector vProd = new Vector();

for (int i =0;i.<a.length;i++){

if(!vProd.contains(a<i>)) vProd.add(a<i>);

}

Collections.sort(vProd);

for(i=0;i<vProd.size();i++){

result.addValue((String)vProd.get(i));

}

input is String[] a

please let me know if any queries..

Regards

Chilla..