XML Parse with same tag name
Posted: Thu May 08, 2008 11:30 am
Hi,
I've never worked with XML string and we have below XML string
<msg><trans><InsertRow>
<col name="PARTY_ID" isKey="1"><char>1INSER </char></col>
<col name="PART_CD" isKey="1"><char>s </char></col>
<col name="INDIV_VER_GMTS" isKey="1"><timestamp>2008-04-22T10:39:06.097000</timestamp></col>
<col name="BIRTH_DT"><date xsi:nil="1"/></col>
<col name="BIRTH_DT_MIS_CD"><char>s</char></col>
<col name="DEATH_DT"><date>2008-04-22</date></col>
</insertRow></trans></msg>
I defined my xml derivation as /msg/trans/insertRow/col/@name
But problem is it always bring the first column and split it in to many rows b'cos all the column has name as col attribute is ther a way the whole data can be bought up in one row.
regards,
I've never worked with XML string and we have below XML string
<msg><trans><InsertRow>
<col name="PARTY_ID" isKey="1"><char>1INSER </char></col>
<col name="PART_CD" isKey="1"><char>s </char></col>
<col name="INDIV_VER_GMTS" isKey="1"><timestamp>2008-04-22T10:39:06.097000</timestamp></col>
<col name="BIRTH_DT"><date xsi:nil="1"/></col>
<col name="BIRTH_DT_MIS_CD"><char>s</char></col>
<col name="DEATH_DT"><date>2008-04-22</date></col>
</insertRow></trans></msg>
I defined my xml derivation as /msg/trans/insertRow/col/@name
But problem is it always bring the first column and split it in to many rows b'cos all the column has name as col attribute is ther a way the whole data can be bought up in one row.
regards,