DSXchange

I have to process multiple XML files with same schema having optional element fields and some fields having multiple roots, is it possible to implement this in Datastage.

I have pasted a sample screenshot for the column FundID which can be available in different roots and I have to take only one value for which it is available.


FundID

1)
<xsd:element name="ROC">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="FundID"/>

2)
<xsd:element name="SellFund">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="FundID"/>

3)
<xsd:element name="BuyFund">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="FundID"/>

4)
<xsd:element name="TrnsfrFund">
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="FundID"/>