Read From XML
Posted: Wed Apr 27, 2011 3:43 am
All,
I have a XML file which is defined as below:
<XML deffinition..>
<endheadertag>
- <sets>
- <set id="0">
. <differents sub-tag>..
.
.
</sets>
my sets tag is repeted less(3times) than my promotions tags(15 times)
<promotions>
.
.
</promotoions>
</endheadertag>
it seems to merge 2 differents axe of XML,
and i am trying to read this xml from xml output but get some strange error
do i have to split them before reading? if yes how to do so?
can anyone explaine in detail what am i wrong for reading my xml?
i use external source and read my xml by ls xmlfile.xml command
then using xml_input
defining/stage/ validate input xml, etat=reject,error=reject,warning=reject
transformation setting/repetation element required, replace emty valu with nulls
input/ xml source coloumn define my input record from external source
-xml document checked
Output/transformation setting -includ namespace declaration('i loaded my schema md5..)
and define a second output for my reject
but where is the problem to read this file?
i am reading the both tags in one times but does not work,
tryed to read them seperately from same xml file, did not work !
i indeed defined description as required
any helps plz?
thank you
I have a XML file which is defined as below:
<XML deffinition..>
<endheadertag>
- <sets>
- <set id="0">
. <differents sub-tag>..
.
.
</sets>
my sets tag is repeted less(3times) than my promotions tags(15 times)
<promotions>
.
.
</promotoions>
</endheadertag>
it seems to merge 2 differents axe of XML,
and i am trying to read this xml from xml output but get some strange error
do i have to split them before reading? if yes how to do so?
can anyone explaine in detail what am i wrong for reading my xml?
i use external source and read my xml by ls xmlfile.xml command
then using xml_input
defining/stage/ validate input xml, etat=reject,error=reject,warning=reject
transformation setting/repetation element required, replace emty valu with nulls
input/ xml source coloumn define my input record from external source
-xml document checked
Output/transformation setting -includ namespace declaration('i loaded my schema md5..)
and define a second output for my reject
but where is the problem to read this file?
i am reading the both tags in one times but does not work,
tryed to read them seperately from same xml file, did not work !
i indeed defined description as required
any helps plz?
thank you