Skip to Content
avatar image
Former Member

Dulicacy of field values in the CSV file

Hi Experts

We are configuring a file to idoc scenario in which the file is a .csv txt file.

The format of the csv file is

NMI,BillNo,BillAmount,ContractAcc

There are instances where there is a duplicacy in the NMI & hence that needs to be filtered before sending it to PI.Any idea about how to filter this either at the source end or PI end.

Please throw some light in this.

Regards

Sabyasachi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Mar 24, 2009 at 09:03 AM

    Hello,

    What kind of filter would you like to apply for NMI?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2009 at 09:12 AM

    Hi Sabyasachi,

    Manually you will need to open the file put it into excel remove duplicate entries , again move that back again into text file. This method is a very dumb way of doing things.

    A smarter way would be to write a module. The link given below is not a tailor made solution to your query but sufficient to get you started.

    https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/99593f86-0601-0010-059d-d2dd39dceaa0

    Regards

    joel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2009 at 09:12 AM

    Hi,

    I don't know what is NMI but there could be 2 possiblities to sort it.

    1. Create an script which will check for the duplicasy of NMI befor PI picks it up.

    2. Let the PI pick up the csv file and then in mapping you handle the duplicasy of NMI.

    And third option is to check the csv file at source side.

    Regards,

    Sarvesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes, what Vijay has suggested is the second option which I mentioned in my first reply. You can handle it in your mapping like this..

      Source> Sort> SplitByValue(Value changed) > CollapseContext>SplitByValue(Each Value)--> Target.

      By this way you can remove your duplicate entries.

  • avatar image
    Former Member
    Oct 07, 2010 at 04:59 AM

    OK

    Add comment
    10|10000 characters needed characters exceeded