[jace427]

I have a need to write a transform that looks a duplicate record set, where one record contains a certain child node and one does not, and copies that child node to the one that doesn't. I am limited to XSLT 1.0 (I have no choice in this situation). In this example the unique identifier than defines a unique record is the "Name" element. The goal is to copy the "Status" element and remove all the records where "id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd" = 2. Thanks in advance... and for not asking WHY I need to do this, that's not the point.

Original XML:

<results>
	<row>
		<Name>Bunnies</Name>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>1</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Elephants</Name>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>1</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Tigers</Name>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>1</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Bunnies</Name>
		<Status>Fluffy</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>2</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Elephants</Name>
		<Status>Huge</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>2</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Tigers</Name>
		<Status>Mean</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>2</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
</results>

Desired Result:

<results>
	<row>
		<Name>Bunnies</Name>
		<Status>Fluffy</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>1</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Elephants</Name>
		<Status>Huge</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>1</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Tigers</Name>
		<Status>Mean</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>1</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Bunnies</Name>
		<Status>Fluffy</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>2</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Elephants</Name>
		<Status>Huge</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>2</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
	<row>
		<Name>Tigers</Name>
		<Status>Mean</Status>
		<id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>2</id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd>
	</row>
</results>

[mojo666]

This should store the appropriate status in a variable for your use.

<xsl:for-each select="row">
  <xsl:variable name="rowName" select="name" />
  <xsl:variable name="Sts" select="../row[name=$rowName and id-f340b6e4-fa71-55cf-d5f3-bc6ccda079fd='2']/Status" />
  <!--Build your result row here-->
</xsl:for-each>

This post has been edited by mojo666: 13 August 2012 - 02:41 PM

[tl8lms]

Mqekligf Eexjg <a href="http://hoganitonline.info/">hogan scarpe</a> Iappnhbl Lejcqv http://hoganitonline.info/

[zc4bov]

Ahhpgvn Moeedi <a href="http://hoganitonline.info/">hogan scarpe</a> Ahbhkd Jiqicn http://hoganitonline.info/