Page 1 of 1

How to extract empty vale from XML schema

Posted: Wed Dec 17, 2008 12:10 pm
by rohit_mca2003
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,

Re: How to extract empty vale from XML schema

Posted: Wed Dec 17, 2008 3:27 pm
by kittu.raja
Hi,

I think you missed the text in the description. Type text() in the column description then you will get the correct result