Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

XSLT: namespace getting added in first element of each group

Received Response
31
Views
1
Comments
Rahul K Kumar
Rahul K Kumar Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

XSLT: namespace getting added in first element of each group

Content

My requirement is to convert below xml file :

<span class="pln" style="font-size: 13px; color: #303336;">     </span><span class="pun" style="font-size: 13px; color: #303336;"><?</span><span class="pln" style="font-size: 13px; color: #303336;">xml version</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="str" style="font-size: 13px; color: #7d2727;">"1.0"</span><span class="pln" style="font-size: 13px; color: #303336;"> encoding</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="str" style="font-size: 13px; color: #7d2727;">"UTF-8"</span><span class="pun" style="font-size: 13px; color: #303336;">?></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;">     <JEES_SSI></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"><P_VAT_ID></span><span class="pln" style="font-size: 13px; color: #303336;">10122</span><span class="tag" style="font-size: 13px; color: #7d2727;"></P_VAT_ID></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;">     <LIST_G_LE_DETAILS></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;">     <G_LE_DETAILS></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;">     <ENTITYNAME></span><span class="pln" style="font-size: 13px; color: #303336;">LE NAME</span><span class="tag" style="font-size: 13px; color: #7d2727;"></ENTITYNAME></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;">     <TAXPAYEID></span><span class="pln" style="font-size: 13px; color: #303336;">A0000000A</span><span class="tag" style="font-size: 13px; color: #7d2727;"></TAXPAYEID></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;">     </G_LE_DETAILS></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;">     </LIST_G_LE_DETAILS><br/></span><span class="pln" style="font-size: 13px; color: #303336;">     </span><span class="tag" style="font-size: 13px; color: #7d2727;"></JEES_SSI></span>

To new xml file :

<span class="pln" style="font-size: 13px; color: #303336;">  </span><span class="pun" style="font-size: 13px; color: #303336;"><?</span><span class="pln" style="font-size: 13px; color: #303336;">xml version</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="str" style="font-size: 13px; color: #7d2727;">"1.0"</span><span class="pln" style="font-size: 13px; color: #303336;"> encoding</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="str" style="font-size: 13px; color: #7d2727;">"UTF-8"</span><span class="pun" style="font-size: 13px; color: #303336;">?></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>  </span><span class="tag" style="font-size: 13px; color: #7d2727;"><siiLR:SuministroLRFacturasRecibidas</span><span class="pln" style="font-size: 13px; color: #303336;"> <br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:siiLR</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"https:/www.firstschema/SLR.xsd"</span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:sii</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="https://www.secondschema/sinfo.xsd" rel="nofollow">https://www.secondschema/sinfo.xsd</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:xsi</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow">http://www.w3.org/2001/XMLSchema-instance</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xsi:schemaLocation</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="https://www.firstschema/" rel="nofollow">https://www.firstschema/</a><span> SLR.xsd"</span></span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:Cabecera></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:Titular></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:NombreRazon></span><span class="pln" style="font-size: 13px; color: #303336;">LE NAME</span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:NombreRazon></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:NIF></span><span class="pln" style="font-size: 13px; color: #303336;">A0000000A</span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:NIF></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:Titular></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>  </span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:Cabecera></span>

<span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"></siiLR:SuministroLRFacturasRecibidas></span>

And i am using below XSL:

<span class="pun" style="font-size: 13px; color: #303336;"><?</span><span class="pln" style="font-size: 13px; color: #303336;">xml version</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="str" style="font-size: 13px; color: #7d2727;">"1.0"</span><span class="pln" style="font-size: 13px; color: #303336;"> encoding</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="str" style="font-size: 13px; color: #7d2727;">"UTF-8"</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="pun" style="font-size: 13px; color: #303336;">?></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:stylesheet</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">version</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"1.0"</span><span class="pln" style="font-size: 13px; color: #303336;">  <br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:xsl</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="http://www.w3.org/1999/XSL/Transform" rel="nofollow">http://www.w3.org/1999/XSL/Transform</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:xsi</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow">http://www.w3.org/2001/XMLSchema-instance</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:siiLR</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"https:/www.firstschema/SLR.xsd"</span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:sii</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="https://www.secondschema/sinfo.xsd" rel="nofollow">https://www.secondschema/sinfo.xsd</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">exclude-result-prefixes</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"sii"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"><br/><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:output</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">method</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"xml"</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">indent</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"yes"</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;">/></span><span class="pln" style="font-size: 13px; color: #303336;"><br/><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:template</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">match</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"/"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:element</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"siiLR:SuministroLRFacturasRecibidas"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:attribute</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"xmlns:siiLR"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:value-of</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">select</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atv" style="font-size: 13px; color: #0f74bd;">"'https:/www.firstschema/SLR.xsd'"</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;">/></xsl:attribute></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:attribute</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"xmlns:sii"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:value-of</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">select</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"'</span><a class="jive-link-external-small" href="https://www.secondschema/sinfo.xsd" rel="nofollow">https://www.secondschema/sinfo.xsd</a><span>'"</span></span><span class="tag" style="font-size: 13px; color: #7d2727;">/></xsl:attribute></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:attribute</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"xsi:schemaLocation"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:value-of</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">select</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"'</span><a class="jive-link-external-small" href="https://www.secondschema/" rel="nofollow">https://www.secondschema/</a><span> sinfo.xsd'"</span></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;">/></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"></xsl:attribute></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:element</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"sii:Cabecera"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:element</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"sii:Titular"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:element</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"sii:NombreRazon"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:value-of</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">select</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atv" style="font-size: 13px; color: #0f74bd;">"JEES_SSI/LIST_G_LE_DETAILS/G_LE_DETAILS/ENTITYNAME"</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;">/></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"></xsl:element></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:element</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">name</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"sii:NIF"</span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"><xsl:value-of</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">select</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atv" style="font-size: 13px; color: #0f74bd;">"JEES_SSI/LIST_G_LE_DETAILS/G_LE_DETAILS/TAXPAYERID"</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;">/></span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="tag" style="font-size: 13px; color: #7d2727;"></xsl:element></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"></xsl:element></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"></xsl:element></span><span class="pln" style="font-size: 13px; color: #303336;">   <br/></span><span class="tag" style="font-size: 13px; color: #7d2727;"></xsl:element></span><span class="pln" style="font-size: 13px; color: #303336;"> </span>

Output i got:

Output is having additional string for xmlns:xmlns="http://www.w3.org/2000/xmlns/" which is causing error: XML Parsing Error: reserved prefix (xmlns) must not be declared or undeclared and namespace is getting added for first element of sii namespace.

<span class="pln" style="font-size: 13px; color: #303336;">   </span><span class="pun" style="font-size: 13px; color: #303336;"><?</span><span class="pln" style="font-size: 13px; color: #303336;">xml version </span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="str" style="font-size: 13px; color: #7d2727;">'1.0'</span><span class="pln" style="font-size: 13px; color: #303336;"> encoding </span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="str" style="font-size: 13px; color: #7d2727;">'UTF-8'</span><span class="pun" style="font-size: 13px; color: #303336;">?></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><siiLR:SuministroLRFacturasRecibidas</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:siiLR</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;">"https:/www.firstschema/SLR.xsd"</span><span class="pln" style="font-size: 13px; color: #303336;"> <br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:xmlns</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="http://www.w3.org/2000/xmlns/" rel="nofollow">http://www.w3.org/2000/xmlns/</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:sii</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="https://www.secondschema/sinfo.xsd" rel="nofollow">https://www.secondschema/sinfo.xsd</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"> <br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:xsi</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow">http://www.w3.org/2001/XMLSchema-instance</a><span>"</span></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="atn" style="font-size: 13px; color: #e64320;">xsi:schemaLocation</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="https://www.firstschema/" rel="nofollow">https://www.firstschema/</a><span> SLR.xsd"</span></span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:Cabecera</span><span class="pln" style="font-size: 13px; color: #303336;"> </span><span class="atn" style="font-size: 13px; color: #e64320;">xmlns:sii</span><span class="pun" style="font-size: 13px; color: #303336;">=</span><span class="atv" style="font-size: 13px; color: #0f74bd;"><span>"</span><a class="jive-link-external-small" href="https://www.secondschema/sinfo.xsd" rel="nofollow">https://www.secondschema/sinfo.xsd</a><span>"</span></span><span class="tag" style="font-size: 13px; color: #7d2727;">></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:Titular></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:NombreRazon></span><span class="pln" style="font-size: 13px; color: #303336;">LE NAME</span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:NombreRazon></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"><sii:NIF></span><span class="pln" style="font-size: 13px; color: #303336;">A0000000A</span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:NIF></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:Titular></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"></sii:Cabecera></span><span class="pln" style="font-size: 13px; color: #303336;"><br/>   </span><span class="tag" style="font-size: 13px; color: #7d2727;"></siiLR:SuministroLRFacturasRecibidas></span>

Please help to correct the xsl file to get desired xml output file. There are two different namespace prefix(siiLr and sii) used for elements in xml file. exclude-result-prefixes="sii" is not excluding the namespace URI from sii:Cabecera.

Answers