How to extract empty vale from XML schema
Posted: Wed Dec 17, 2008 12:10 pm
Hi,
I have input as follows (2 records) in XML file:
<mandatory>true</mandatory>
<subsection></subsection>
<question>XYZ</question>
<currentQuestion>false</currentQuestion>
<mandatory>true</mandatory>
<subsection>123</subsection>
<question>ABCD </question>
<Question>false</Question>
When I am extracting the values using XML input stage into dataset it gives me following result:
question subsection
-----------------------------
XYZ <subsection></subsection><subsection>123</subsection>
ABCD <subsection></subsection><subsection>123</subsection>
However I want result in following format:
question subsection
-----------------------------
XYZ NULL/Space
ABCD 123
Could any one help me please. Thanx in advance!!
Regards,
I have input as follows (2 records) in XML file:
<mandatory>true</mandatory>
<subsection></subsection>
<question>XYZ</question>
<currentQuestion>false</currentQuestion>
<mandatory>true</mandatory>
<subsection>123</subsection>
<question>ABCD </question>
<Question>false</Question>
When I am extracting the values using XML input stage into dataset it gives me following result:
question subsection
-----------------------------
XYZ <subsection></subsection><subsection>123</subsection>
ABCD <subsection></subsection><subsection>123</subsection>
However I want result in following format:
question subsection
-----------------------------
XYZ NULL/Space
ABCD 123
Could any one help me please. Thanx in advance!!
Regards,