XSLT help

cooltechie · January 28th, 2010, 01:28 AM

Input XML 1:
<Root>
<Book>
<ID>1</ID>
<ref>regh</ref>
</Book>

<Book>
<ID>2</ID>
<ref>regh</ref>
</Book>

<Book>
<ID>3</ID>
<ref>regh</ref>
</Book>

<Book>
<ID>4</ID>
<ref>regh</ref>
</Book>
</Root>

I want an output:

<Root>
<Book>
<ID>1</ID>
<ref>regh</ref>
<NewField1>a</NewField1>
<NewField2>b</NewField2>
<NewField3>c</NewField3>
</Book>

<Book>
<ID>2</ID>
<ref>regh</ref>
<NewField1>1</NewField1>
<NewField2>2</NewField2>
<NewField3>3</NewField3>
</Book>

<Book>
<ID>3</ID>
<ref>regh</ref>
<NewField1>i</NewField1>
<NewField2>ii</NewField2>
<NewField3>iii</NewField3>
</Book>

<Book>
<ID>4</ID>
<ref>regh</ref>
<NewField1>sa</NewField1>
<NewField2>sd</NewField2>
<NewField3>sd</NewField3>
</Book>
</Root>

and have these newField values in seperate XML

where:

input XML 2

<Root>
<Book>
<ID>1</ID>
<NewField1>a</NewField1>
<NewField2>b</NewField2>
<NewField3>c</NewField3>
</Book>

<Book>
<ID>2</ID>
<NewField1>1</NewField1>
<NewField2>2</NewField2>
<NewField3>3</NewField3>
</Book>

<Book>
<ID>3</ID>
<NewField1>i</NewField1>
<NewField2>ii</NewField2>
<NewField3>iii</NewField3>
</Book>

<Book>
<ID>4</ID>
<NewField1>sa</NewField1>
<NewField2>sd</NewField2>
<NewField3>sd</NewField3>
</Book>
</Root>

So basically, I would like to apply an XSLT to this two input XMLs and get the desired output as shown above.

mrame · January 28th, 2010, 04:12 AM

Try the below:

Code:

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

<xsl:output method="xml" indent="yes"/>

<xsl:variable name="doc" select="doc('file:///file-path-of-input2/2.xml')"/>

<xsl:template match="Root">
	<xsl:copy>
<xsl:for-each select="Book">

<xsl:copy>
<xsl:variable name="id" select="ID"/>
<xsl:copy-of select="ID"/>
<xsl:copy-of select="ref"/>
<xsl:copy-of select="$doc/Root/Book[ID = $id]//NewField1"></xsl:copy-of>
<xsl:copy-of select="$doc/Root/Book[ID = $id]//NewField2"></xsl:copy-of>
<xsl:copy-of select="$doc/Root/Book[ID = $id]//NewField3"></xsl:copy-of>
	</xsl:copy>

</xsl:for-each>
</xsl:copy>
</xsl:template>

mhkay · January 28th, 2010, 04:19 AM

If you are using XSLT 2.0, you can do this with grouping:

Code:

<xsl:for-each select="doc('d1.xml')/Root/Book, doc('d2.xml')/Root/Book"
  group-by="ID">
  <Book>
     <xsl:copy-of select="current-group()/(ID[1], ref, NewField1, NewField2, NewField3)"/>
  </Book>
</xsl:for-each>

cooltechie · January 28th, 2010, 05:04 AM

Sorry I am using XSLT 1.0 and Rummy's Solution did not work for me.

mrame · January 28th, 2010, 06:42 AM

Try the below:

Code:

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

<xsl:output method="xml" indent="yes"/>

<xsl:variable name="doc" select="document('file:///file-path-of-input2/2.xml')"/>

<xsl:template match="Root">
	<xsl:copy>

<xsl:for-each select="Book">
<xsl:copy>
<xsl:variable name="id" select="ID"/>
<xsl:copy-of select="ID"/>
<xsl:copy-of select="ref"/>
<xsl:copy-of select="$doc/Root/Book[ID = $id]//NewField1"></xsl:copy-of>
<xsl:copy-of select="$doc/Root/Book[ID = $id]//NewField2"></xsl:copy-of>
<xsl:copy-of select="$doc/Root/Book[ID = $id]//NewField3"></xsl:copy-of>
	</xsl:copy>
</xsl:for-each>

</xsl:copy>
</xsl:template>

cooltechie · January 28th, 2010, 09:31 AM

hi rummy

it did not work. the new fields are not eing copied in the output,

Martin Honnen · January 28th, 2010, 09:36 AM

See the solution posted in http://forums.tizag.com/showthread.php?t=17937
If you still have problems then you will need to tell us enough details to allow us to reproduce the problem, such as the XSLT processor you use, how you run, the result you want and the result you get.

cooltechie · January 28th, 2010, 12:21 PM

Hi Martin,

I am using a commandline tool, which takes three input parameters, the input xml , the stylesheet, and the output file name.

The parser is : MSXML2.DOMDocument.4.0

Please let me know ,

Martin Honnen · January 28th, 2010, 12:30 PM

Quote:

Originally Posted by cooltechie

Hi Martin,

I am using a commandline tool, which takes three input parameters, the input xml , the stylesheet, and the output file name.

The parser is : MSXML2.DOMDocument.4.0

Please let me know ,

Does that command line tool allow you to set a stylesheet parameter? You will either need to do that or you will need to edit the stylesheet and set the default value of the parameter in the stylesheet before you run the transformation.

cooltechie · January 28th, 2010, 12:40 PM

The Result I am getting is the same Input document that I am providing.

I am not seeing the Newfield Elements being added to the resulting output.

I have my input XML, xsl and the document that I am pointing to use document function, and the commandline tool all saved in the same directory.

so I am using this:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<xsl:stylesheet
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>

<xsl:output encoding="UTF-8" method="xml"/>

<xsl:param name="dataurl" select="'book.xml'"/>
<xsl:variable name="bookdata" select="document($dataurl)"/>

<xsl:param name="dataurl" select="'book.xml'"/>
<xsl:variable name="bookdata" select="document($dataurl)"/>

<xsl:output indent="yes"/>

<xsl:key name="k1" match="book" use="ID"/>

<xsl:template match="/|@* | node()">
<xsl:copy>
<xsl:apply-templates select="@* | node()"/>
</xsl:copy>
</xsl:template>

<xsl:template match="book">
<xsl:variable name="id" select="ID"/>
<xsl:copy>
<xsl:apply-templates select="@* | node()"/>
<xsl:for-each select="$bookdata/book">
<xsl:apply-templates select="key('k1', $id)/*[starts-with(local-name(), 'NewField')]"/>
</xsl:for-each>
</xsl:copy>
</xsl:template>

<xsl:template match="NewField">

<NewField>

<xsl:value-of select="."/>
</NewField>

</xsl:template>

</xsl:stylesheet>