Help in Processing XML File
Posted: Thu Aug 25, 2011 6:22 am
Hi Guys,
I need to Read XML file and put it to different Columns.
My I/P is
I am reading it as single column and passing it to XML Reader Stage. I have defined 6 columns. Following are the derivation i have given
The records are reaching XML Reader and no output is coming from the REader stage.
Can somebody help me out.
Cheers!!!!!
I need to Read XML file and put it to different Columns.
My I/P is
Code: Select all
<?xml version=""1.0"" encoding=""UTF-8"" standalone=""no""?>
<pricing-model>
<qualifier>
<next>
<collection-name>items</collection-name>
<element-name>item</element-name>
<element-quantity-property>quantity</element-quantity-property>
</next>
</qualifier>
</pricing-model>
Code: Select all
/pricing-model/qualifier/next/collection-name/text()
/pricing-model/qualifier/next/element-name/text()
/pricing-model/qualifier/next/element-quantity-property/text()
/pricing-model/qualifier/next/equals/value/text()
/pricing-model/qualifier/next/equals/constant/data-type/text()
/pricing-model/qualifier/next/equals/constant/string-value/text()
The records are reaching XML Reader and no output is coming from the REader stage.
Can somebody help me out.
Cheers!!!!!