Duplicate Records

[Former Member]

HI Group,

In File to File Scenario how to avoid duplicate records

[Former Member]

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

[prabhu_s2]

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

[Former Member]

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

[Former Member]

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

Regards

Sreeram.G.Reddy

[Former Member]

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

[MichalKrawczyk]

Hi,

Don't send the same file twice

Regards,

michal

[Former Member]

HI Michal,

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

[udo_martens]

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