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"/>
Complex XML file with optional element and multiple root
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 32
- Joined: Tue Mar 09, 2010 5:56 am
- Location: Bangalore
Complex XML file with optional element and multiple root
Thanks & Regards,
Partha
Partha