Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating multiple rows from one record in xslt

3426083Jun 13 2019 — edited Jun 14 2019

Dear All,

I need to fetch one csv file which is currently having one record. I am using 11.1.1.7 soa suite file adapter to pull record and pushing to DB table(with multiple rows).

<Receive1_Read_InputVariable>

<Root-Element>

<RECORD1> //header fields

<C2>Plant</C2>

<C3>TimeStamp</C3>

<C4>Amine</C4>

<C5>Amine_UOM</C5>

<C6>Carbon</C6>

<C7>Carbon_UOM</C7>

<C8>Corrosion</C8>

<C9>Corrosion_UOM</C9>

</RECORD1>

<RECORD2> //csv values corresponding header

<C5/>

<C7/>

<C9/>

</RECORD2>

</Root-Element>

</part>

</Receive1_Read_InputVariable>

Now requirement is to create 3 rows from above input like one for Aminie ,Carbon and Corrosion

transformed Output:

<SAW_RAW>

<plant_txns>

<plant_code>SAW</plant_code>

<tag>Aminie</tag>

<tag_value>36693.6087285655</tag_value>

<tag_date>06/10/2019</tag_date>

</plant_txns>

<plant_txns>

<plant_code>SAW</plant_code>

<tag>Carbon</tag>

<tag_value>1861.09620848459</tag_value>

<tag_date>06/10/2019</tag_date>

</plant_txns>

<plant_txns>

<plant_code>SAW</plant_code>

<tag>Corrosion</tag>

<tag_value>105039.572083346</tag_value>

<tag_date>06/10/2019</tag_date>

</plant_txns>

</SAW_RAW>

Can you please assist how we can achieve it.

Appreciate your earlier reply.

Thanks

Added on Jun 13 2019

#soa-process-management, #soa-suite-discusssions

1 comment

1,263 views