on 10-10-2007 3:37 PM
My scenario is as follows
FILE ---> XI ---> FILE
The data is exchanged as XML. The structure is pretty simple, multiple records exist in a file and each record has multiple columns.
No mapping required. This interface is currently in production in our environment.
We have a requirement now to split the target file into multiple files by date. The data is a column in the payload. So we need to combine all records that have the same date into their own separate target files.
I dont want to use ccBPM due to the performance overhead it has. I dont have any other mapping requirements other than this.
Does anyone have any idea on how this can be done?
Regards
Haseeb
We have a requirement now to split the target file into multiple files by date. The data is a column in the payload. So we need to combine all records that have the same date into their own separate target files.
use the variable substution selecte date field as the file name and file const modechoose append:
this will put all the records which has same date in the one file...
this should work out
Message was edited by:
n Khan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Khan,
Can you provide more details of your solution.
This can help me and others understand it better.
Based on your previous suggestion, I have tried it and it doesnt solve my problem exactly in my scenario.In my case, I have a single message which needs to be split into multiple messages based on the date in the payload. The file name for each message split need to have the date from the payload.
Anyway, your solution in detail can help me understand if I am missing anything.
Regards
Haseeb
You have to handle this in mapping. You do not need to use BPM.
This will be better handled if you use ABAP / JAVA Mapping instead of graphical.
Thanks and Regards,
Himadri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
May not be a good solution but analyse and try to implement.
in general for a message
root node -- 1..1 or 0..1 as occurrences
recordset -- 0..unbound as occurrences
Now Change it to
Message1 -
0..unbound to come (optional)
root node -- 0..unbound as occurrences
recordset -- 0..unbound as occurrences
Before doing the below you need to do the sortind based on the date and per eache message one date records shhould be populated.. handle in UDF
message should be created multiple times.. .. no need to handle in adapter level , you need to handle in interface determination level.. check the below link
it will be created multiple..
see the below link
http://help.sap.com/saphelp_nw70/helpdata/en/42/ed364cf8593eebe10000000a1553f7/content.htm
Chilla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.