SSDN - XSLT for dynamic target fields

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Conferences

	Stylus Studio Feature Requests (1192)
	Stylus Studio Technical Forum (14621)
	Website Feedback (249)
	XSLT Help and Discussion (7625)
	Use of before and after string (3)
	How do I substitute element ty... (1)
	How does one add working days ... (4)
	Help, I have existing XLT and... (1)
	Need help on XSLT issue - (2)
	EDI to XML Conversion (7)
	XML To JSON Conversion using X... (1)
	Formatting Paragraphs to same ... (2)
	Grouping of records (1)
	Problems with xsd 1.1 (4)
	XML to HL7 mapping (3)
	XSLT 3 and Iterate (2)
	XSL-FO to PDF preview (3)
	java.lang.RuntimeException: Er... (2)
	Create Acroforms with Stylus X... (2)
	How to change XSLT parameter s... (3)
	how to change format of the da... (2)
	Search "Next 8 Results " doesn... (2)
	Support for Git (1)
	newbee (8)
	[1-20] [21-40] [41-60] Next
	XQuery Help and Discussion (2017)
	Stylus Studio FAQs (159)
	Stylus Studio Code Samples & Utilities (364)
	Stylus Studio Announcements (113)

Topic

Nagarjuna S

Subject: XSLT for dynamic target fields
Author: Nagarjuna S
Date: 18 Jul 2011 03:43 PM

Hello,

Input XML -

<?xml version="1.0" encoding="UTF-8"?>
<Createelement_MT>
<Field Name="A">
<Value>1</Value>
</Field>
<Field Name="B">
<Value>1</Value>
</Field>
...
</Createelement_MT>

Expected OutPut XML -

<?xml version="1.0" encoding="UTF-8"?>
<Createelement_MT>
<Statement><TableName><table>XYZ</table>
<access>
<A>1</A>
<B>2</B>
..
</access>
</Statement></TableName>
</Createelement_MT>

The value of the attribute 'Name' of field 'Field' should be the name of target field.

XSLT:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml"/>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="Createelement_MT">
<xsl:element name="statement">
<xsl:element name="TableName">
<xsl:element name="table">ABC</xsl:element>
<xsl:element name="access">
<xsl:for-each select="Field">
<xsl:element name="{@Name}">
<xsl:value-of select="Value"></xsl:value-of></xsl:element></xsl:for-each>
</xsl:element>
</xsl:element>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

Error:
Error: at xsl:element on line 15 of file:///......: XTDE0820: Invalid element name. Invalid QName {}

Please help me with the xslt code for this requirement.
Thanks!

Ivan Pedruzzi

Subject: XSLT for dynamic target fields
Author: Ivan Pedruzzi
Date: 20 Jul 2011 11:09 PM

Use the following approach to ensure that the element name is valid NCNAME

<xsl:element name="{translate(@Name, translate(@Name, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ_'), '_')}">
<xsl:value-of select="Value"></xsl:value-of>
</xsl:element>

Nagarjuna S

Subject: XSLT for dynamic target fields
Author: Nagarjuna S
Date: 21 Jul 2011 12:37 PM

Thanks for the reply.

Iam getting an error saying - the truncate fn should have 3 arguments.

I have changed the code as follows and its working as expected now.

<xsl:for-each select="Createelement_MT/Field">
<xsl:variable name="field" select="normalize-space(@Name)"></xsl:variable>
<xsl:element name="{$field}">
<xsl:value-of select="Value"></xsl:value-of>

Ivan Pedruzzi

Subject: XSLT for dynamic target fields
Author: Ivan Pedruzzi
Date: 22 Jul 2011 10:58 PM

Sorry the correct code is below

Watch out because normalize-space only trims leading and trailing whitespace characters and replacing sequences of whitespace characters by a single space.

If the attribute value in your input XML may contain an invalid QName then sooner or later you will get a runtime error

Hope this helps
Ivan

here a quick example

======================
input XML

<Createelement_MT>
<Field Name="A">
<Value>A</Value>
</Field>
<Field Name=" space ">
<Value> space </Value>
</Field>

<Field Name="3number">
<Value>3number</Value>
</Field>
</Createelement_MT>

=================================
XSLT

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml"/>
<xsl:template match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="Createelement_MT">
<xsl:element name="statement">
<xsl:element name="TableName">
<xsl:element name="table">ABC</xsl:element>
<xsl:element name="access">
<xsl:for-each select="Field">
<xsl:element name="{translate(@Name, translate(@Name, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ_', ''), '_')}">
<xsl:value-of select="Value"/>
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:element>
</xsl:element>
</xsl:template>
</xsl:stylesheet>

====================================
Output XML

<statement>
<TableName>
<table>ABC</table>
<access>
<A>A</A>
<_space_>space</_space_>
<_number>3number</_number>
</access>
</TableName>
</statement>

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.