XSLT help to include a field in an XML

Inaphtape

New Member
I have following XML:\[code\]<?xml version="1.0" encoding="utf-8"?><Rowsets> <Rowset> <Columns> <Column Description="DrilldownDepth" MaxRange="1" MinRange="0" Name="DrilldownDepth" SQLDataType="4" SourceColumn="DrilldownDepth"/> <Column Description="ABC" MaxRange="1" MinRange="0" Name="ABC" SQLDataType="4" SourceColumn="ABC"/> <Column Description="DEF" MaxRange="1" MinRange="0" Name="DEF" SQLDataType="-1" SourceColumn="DEF"/> <Column Description="PQR" MaxRange="1" MinRange="0" Name="PQR" SQLDataType="-1" SourceColumn="PQR"/> </Columns> <Row> <DrilldownDepth>1</DrilldownDepth> <ABC>25</ABC> <DEF>DDD</DEF> <PQR>PPP</PQR> </Row> <Row> <DrilldownDepth>1</DrilldownDepth> <ABC>16</ABC> <DEF>AAA</DEF> <PQR>BBB</PQR> </Row> <Row> <DrilldownDepth>1</DrilldownDepth> <ABC>19</ABC> <DEF>SEE</DEF> <PQR>HELP</PQR> </Row> </Rowset></Rowsets>\[/code\]Now I need to add in every Row. hence my XML will look like following:\[code\]<?xml version="1.0" encoding="utf-8"?><Rowsets> <Rowset> <Columns> <Column Description="DrilldownDepth" MaxRange="1" MinRange="0" Name="DrilldownDepth" SQLDataType="4" SourceColumn="DrilldownDepth"/> <Column Description="ABC" MaxRange="1" MinRange="0" Name="ABC" SQLDataType="4" SourceColumn="ABC"/> <Column Description="DEF" MaxRange="1" MinRange="0" Name="DEF" SQLDataType="-1" SourceColumn="DEF"/> <Column Description="PQR" MaxRange="1" MinRange="0" Name="PQR" SQLDataType="-1" SourceColumn="PQR"/> </Columns> <Row> <DrilldownDepth>1</DrilldownDepth> <ABC>25</ABC> <DEF>DDD</DEF> <PQR>PPP</PQR> <XYZ></XYZ> </Row> <Row> <DrilldownDepth>1</DrilldownDepth> <ABC>16</ABC> <DEF>AAA</DEF> <PQR>BBB</PQR> <XYZ></XYZ> </Row> <Row> <DrilldownDepth>1</DrilldownDepth> <ABC>19</ABC> <DEF>SEE</DEF> <PQR>HELP</PQR> <XYZ></XYZ> </Row> </Rowset></Rowsets>\[/code\]How can I achive this using transform / XSLT?I tried various XSLT but somehow I am not able to achieve it.Soham
 
Back
Top