on 03-18-2015 11:01 AM
Hi Guys,
Can somebody please help me and let me know how to get the required output.
I have a IDOC to File scenario where I need to produce the output like this.
RECORD_1.FIELD1,RECORD_1.FIELD2
RECORD_2.FIELD1,RECORD_2.FIELD2
RECORD_3.FIELD1,RECORD_3.FIELD2
RECORD_4.FIELD1,RECORD_4.FIELD2
RECORD_1.FIELD1,RECORD_1.FIELD2
RECORD_2.FIELD1,RECORD_2.FIELD2
RECORD_3.FIELD1,RECORD_3.FIELD2
RECORD_4.FIELD1,RECORD_4.FIELD2
I have created the structure like this but it is not producing any output and failing with the error.
Recordset 1...unbounded
RECORD_1 1..1
FIELD1
FIELD2
RECORD_2 1..1
FIELD1
FIELD2
RECORD_3 0..1
FIELD1
FIELD2
RECORD_4 0..1
FIELD1
FIELD2
Error : Recordset.fieldNames and Recordset.fieldSeparator
Is it possible to generate the required output without XSLT/Java mapping?
Can somebody please suggest.
Many Thanks,
Asif
Hi Asif,
You can use below content conversion.
Receiver XML:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:FileReceiverData xmlns:ns0="urn:ch:test:prototype">
<RECORDS>
<RECORD_1>
<Field1>11</Field1>
<Field2>AA</Field2>
<Field3>BB</Field3>
</RECORD_1>
<RECORD_2>
<Field1>22</Field1>
<Field2>CC</Field2>
<Field3>DD</Field3>
</RECORD_2>
<RECORD_3>
<Field1>33</Field1>
<Field2>EE</Field2>
<Field3>FF</Field3>
</RECORD_3>
<RECORD_4>
<Field1>44</Field1>
<Field2>GG</Field2>
<Field3>HH</Field3>
</RECORD_4>
</RECORDS>
<RECORDS>
<RECORD_1>
<Field1>11</Field1>
<Field2>AA</Field2>
<Field3>BB</Field3>
</RECORD_1>
<RECORD_2>
<Field1>22</Field1>
<Field2>CC</Field2>
<Field3>DD</Field3>
</RECORD_2>
<RECORD_3>
<Field1>33</Field1>
<Field2>EE</Field2>
<Field3>FF</Field3>
</RECORD_3>
<RECORD_4>
<Field1>44</Field1>
<Field2>GG</Field2>
<Field3>HH</Field3>
</RECORD_4>
</RECORDS>
</ns0:FileReceiverData>
Output File:
Regards,
Praveen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Asif,
In the mapping you concate the fields of respective recordset1,2,..etc.
Like this Concate RECORD_1. to field1 and the same to RECORD_1. to field2.
Make your FCC structure like this
Recordset,Record_1,Record_2,Record_3,Record_4
and made the parameters like this
Recordset.fieldSeparator /n
Recordset.endSeparator /n
Record_1.fieldSeparator ,
Record_1.endSeparator /n
like this for Record_2,3,4......
Regards,
Suhale Shaik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
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.