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