Skip to Main Content

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!

XSLT - repeating the target schema based on repetition of input node

rohit janaJul 23 2013 — edited Feb 26 2020

Hi All,

I a requirement where all the elements in the target schema of the transformation must repeat based on repetition if a id in the input schema.

XML 1:

<root>

<Productcollection>

<productdesc>string 1</productdesc>

productmanfdate>mm/dd/yyyy</productmanfdate>

<ProductID>

<productCode>100</productCode>

<productCode>101</productCode>

<productCode>102</productCode>

</ProductID>

</Productcollection>

</root>

the required output XML is:

<root>

<Productcollection>

<productdesc>string 1</productdesc>

productmanfdate>mm/dd/yyyy</productmanfdate>

<productCode>100</productCode>

</Productcollection>

<Productcollection>

<productdesc>string 1</productdesc>

productmanfdate>mm/dd/yyyy</productmanfdate>

<productCode>101</productCode>

</Productcollection>

<Productcollection>

<productdesc>string 1</productdesc>

productmanfdate>mm/dd/yyyy</productmanfdate>

<productCode>102</productCode>

</Productcollection>

</root>

Can anyone please help me out on how to do this type of transformation.

Thanks

This post has been answered by PuneetRekhade on Jul 23 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2013
Added on Jul 23 2013
6 comments
839 views