on 03-24-2009 7:27 AM
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
OK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Regards
joel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
What kind of filter would you like to apply for NMI?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.