How to extract empty vale from XML schema

[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,

[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