Duplicate records while loading data Transaction data from flat file.

[Former Member]

Hi,

we are working on NW BPC 10.0

We have to use same transaction data flat file for different transformation files. Below are my sample transformation files and flat file.

For first transformation file we are getting duplicate records while loading data.

Please help us how to eliminate those.

Thanks in Advance.

Regards

Anitha.

[Former Member · Accepted solution]

Hi,

we don't want duplicate records.

we have used /CPMB/IMPORT process chain. It is working.

[gajendra_moond]

Hi Anitha

Please check mapping of your Entity and Cost Center. Shouldn't it be

ENTITY=*COL(3) rather than *COL(2) and

COSTCENTER=*COL(4) rather than *COL(3)? You should not have a problem of duplicate records for transaction data load.

[Former Member]

Hi Anitha,

I depends on you, whether you want the duplicates entry or  not. Implemented a BADI  and write a Code in end routine.

If you need the duplicated entries, you can do the aggregation of values, if you don't need, u can removes duplicates also.

rohit

[Former Member]

Hi Anitha,

Use a start routine to sum up those duplicate records for you,

or use excel to sum up those duplicate records manually then load using that file,

or during the export of the source file ask the program to sum it up for you.

Andy