Insert multiple elements based on values of others

Martin Honnen · September 17th, 2009, 12:40 PM

Hmm, removing an XML declaration in the XML input fixes the stylesheet result? That sounds rather odd.
As for the check I think you want to change the template for '' elements to the following:

Code:

  <xsl:template match="REF">
    <xsl:copy>
      <xsl:apply-templates select="@* | L_TO_C"/>
      <xsl:if test="not(doc2c)">
        <xsl:apply-templates select="/Tremble/Dakota/doc" mode="m1"/>
      </xsl:if>
      <xsl:apply-templates select="r2p"/>
    </xsl:copy>
  </xsl:template>

fixit · September 17th, 2009, 01:09 PM

The stylesheet needs another tweak. It looks like elements in the original EMB container are getting output into doc2c. How can I fix this?

Result xml is below:

Code:

<Tremble>
	<Dakota>
		<L>
			<Li>123456</Li>
		</L>
		<C>
			<CID>69538</CID>
		</C>
		<PAR/>
		<PAR/>
		<doc>
			<EMB>
				<pinfo>
					<pid>2</pid>
					<pd>desc</pd>
				</pinfo>
				<enc>
					<pic>gberish2</pic>
				</enc>
			</EMB>
			<docid>1</docid>
			<dt>pho</dt>
		</doc>
		<doc>
			<EMB>
				<pinfo>
					<pid>4</pid>
					<pd>desc</pd>
				</pinfo>
				<enc>
					<pic>gberish4</pic>
				</enc>
			</EMB>
			<docid>2</docid>
			<dt>pho</dt>
		</doc>
		<doc>
			<EMB>
				<pinfo>
					<pid>6</pid>
					<pd>desc</pd>
				</pinfo>
				<enc>
					<pic>gberish6</pic>
				</enc>
			</EMB>
			<docid>3</docid>
			<dt>pho</dt>
		</doc>
		<REF>
			<L_TO_C>
				<L>123</L>
				<CID>69538</CID>
			</L_TO_C>
			<doc2c>2descgberish2<docid>1</docid>pho<CID>69538</CID></doc2c>
			<doc2c>4descgberish4<docid>67</docid>pho<CID>69538</CID></doc2c>
			<doc2c>6descgberish6<docid>45</docid>pho<CID>69538</CID></doc2c>
			<r2p>part1</r2p>
			<r2p>part1</r2p>
		</REF>
		<DID/>
	</Dakota>
	<ver>22</ver>
</Tremble>

Martin Honnen · September 18th, 2009, 06:25 AM

Here is an adapted stylesheet:

Code:

<xsl:stylesheet version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

  <xsl:strip-space elements="*"/>
  <xsl:output indent="yes"/>
  
  <xsl:template match="@* | node()">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="doc/docid">
    <xsl:copy>
      <xsl:number count="doc"/>
    </xsl:copy>
  </xsl:template>
  
  <xsl:template match="REF">
    <xsl:copy>
      <xsl:apply-templates select="@* | L_TO_C"/>
      <xsl:if test="not(doc2c)">
        <xsl:apply-templates select="/Tremble/Dakota/doc" mode="m1"/>
      </xsl:if>
      <xsl:apply-templates select="r2p"/>
    </xsl:copy>
  </xsl:template>

  <xsl:template match="doc" mode="m1">
    <doc2c>
      <xsl:apply-templates select="docid" mode="m1"/>
      <xsl:apply-templates select="/Tremble/Dakota/C/CID"/>
    </doc2c>
  </xsl:template>
  
  <xsl:template match="doc/docid" mode="m1">
    <xsl:copy>
      <xsl:apply-templates/>
    </xsl:copy>
  </xsl:template>

</xsl:stylesheet>

fixit · September 24th, 2009, 04:52 PM

I successfully implemented this solution with XMLSpy and tested the transformation with the built in XLST processor and the MSXML processor you can switch to. However, I am told by an associate that the transform does not work correctly when using the XslCompiledTransform class and the Transform method, using VB.NET running in SQL Server Integration Services. That is, the new elements are not inserted.

Could there be a nuance that makes this not work in that system? I understand that that class is based on XSLT 1.0? Is there something related to 2.0 that is in this code? Thanks for your assistance again.

Martin Honnen · September 25th, 2009, 05:36 AM

Both MSXML and XslCompiledTransform are XSLT 1.0 processors. Furthermore the stylesheet in Insert multiple elements based on values of others is an XSLT 1.0 stylesheet.

We can try to look into why it fails with XslCompiledTransform: to do that please post minimal but complete input and stylesheet samples that fail.