Skip to Content
avatar image
Former Member

Duplicate records while loading data Transaction data from flat file.

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.

FLAT FILE.PNG (36.1 kB)
TRANs file 1.PNG (5.2 kB)
TRANs file 2.PNG (5.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2015 at 02:03 PM

    Hi,

    we don't want duplicate records.

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 06, 2015 at 05:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 06, 2015 at 05:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2015 at 02:03 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded