XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Transform a XML file with simple type nodes to complex type nodes
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> - XSLT slicing and orphan contro... (1)
-> + How to delete CDATA using XSL... (15)
-> + Remove only root namespace, bu... (3)
-> + String Parsing (3)
-> + Calling Java method from XSL (3)
-> + populate xsl file from xsd fil... (5)
-> + formating a number like #'###.... (3)
-> + Help with grouping children, f... (20)
-> + Need help for newbie! (3)
-> + xpath in string format (2)
-> + How to populate elements at ra... (4)
-> + Changing Date format in XLST (2)
-> + Please help....How could I rem... (2)
-> + Counting children and grandchi... (7)
-> + Nested tags (4)
-> + Problem with XSLT on a Soap En... (2)
-> + Problem with XSLT on a Soap En... (5)
-> + Comparison between XSLT proces... (2)
-> + Printing non-existing value (9)
-> + big input file for XSLT (14)
-> + Is there any way to store xpat... (2)
-> + Encoding special charecters (2)
-> + Sorting (3)
-> + XML to PDF using XSL:FO (3)
-> + How to find the line number in... (2)
-> + How to set a marker for paper ... (2)
-> + Not equality Function (2)
-> + Counting Elements (4)
-> + Looking for help or code samp... (2)
-> + Help needed in pattern matchin... (2)
-> + Repeaters and Ifs (2)
-> + select adjacent nodes in xpath... (3)
-> + Stripping of Empty Target Elem... (2)
-> + auto-generate Edifact Intercha... (5)
-> + Qname Error in xsl:element (2)
-> + [Newbie] Type conversion and f... (2)
-> + Do ...when (2)
-> + Using Key (3)
-> + sorting elements in option (2)
-> + NaN(not available) value repla... (3)
-> + infinite loop error when tryin... (9)
-> + Escape a character in the stri... (3)
-> + find sum of 2 elements in xml (2)
-> + placing a ' * ' by reading the... (3)
-> + Problem in dispaying Current D... (4)
-> + Merging Table Cells in XSLT re... (3)
-> + xsl fo block-container and foo... (2)
-> + Is is possible to create a .CO... (2)
-> + printing a parent node value i... (2)
-> + Mime header info setup? (3)
-> + Calculating a Date based on 4 ... (3)
-> + XSLT formatting number issue (10)
-> + map repeating elements separat... (3)
-> + Combining XML elements based o... (3)
-> + Convert XML to UTF-8 (8)
-> + XSLT and MS Access 2007 Optio... (5)
-> - WORDML list to XML list (1)
-> + [Newbie] Using lookups in XSLT... (3)
-> + Comparing 2 passed Date Values (2)
-> + ERROR XQueryMediator Error du... (2)
-> + XML / XSLT... Unordered lists ... (2)
-> + Specify image path in XSL (2)
-> + Variable within a variable (3)
-> + How to call jfreechart method ... (8)
-> + leading and trailing white spa... (2)
-> + XSLT to Html problems (6)
-> + How to set classpath, when i n... (3)
-> + Error in using functions (4)
-> + To find the occurence of a cha... (3)
-> + PLMXML to XML (4)
-> + Transform multiple node values... (2)
-> + I am in need of svg example(s)... (13)
-> + count in XSLT, Need Help Pleas... (2)
-> + Help with XML.Report and Gener... (2)
-> + for each loop and variable (5)
-> + Problem with selecting nodes f... (3)
-> + Getting "Expected elemenmt mis... (2)
-> + Help with attached XML mapping... (8)
-> + xml:space="Preserve" and Embed... (2)
-> + XSLT and Multiple Strings (2)
-> + XSL Date format (2)
-> + check element contents against... (3)
-> + XML to XML Namespace conversio... (2)
-> - Supressing subgroup headers in... (1)
-> - HTML to fo conversion using XS... (1)
-> + No Topic (2)
-> + parsing xml using xslt HELP (2)
-> + Multiple Page Headers (2)
-> + PLM Xml To Generic XML (3)
-> + XSLT/XPath Help (2)
-> + XSL Space Issue (2)
-> + wanting help with xslt custom ... (3)
-> - Update input xml content with ... (1)
-> + Error: namespace prefix xsl on... (3)
-> + Error in my xsl:if test... (2)
-> - calling javascript from XSLT (1)
-> + Error when trying to a call a ... (2)
-> - HTTP POST from XSLT (1)
-> + passing xml document as input ... (2)
-> + XSLT for WORDML table to CALS ... (2)
-- Previous [361-380] [381-400] [401-420] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Kalyani YemcheSubject: Transform a XML file with simple type nodes to complex type nodes
Author: Kalyani Yemche
Date: 05 Apr 2005 09:49 AM
Hi ,
I am trying to transform following file to a file with complex nodes.
The source file contains all the info in two simple records and I want it in a linked format.
For example, here for each header there may be many manufacturers linked with it,
for each manufacturer, there may be many product types and so on till individual items represented by <item> tags.
I am new to XSLT but still I tried a lot.Please do help me if any one can.


Source file:


<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<headervalue>54</headervalue>
<manufid>1</manufid>
<manufname>Manuf1</manufname>
<headoffice>HO1</headoffice>
<productid>1</productid>
<description>Desc1</description>
<dateofmfg>2004-08-05</dateofmfg>
<itemprice>300.0000</itemprice>
</Table>
<Table>
<headervalue>54</headervalue>
<manufid>1</manufid>
<manufname>Manuf2</manufname>
<headoffice>HO1</headoffice>
<productid>2</productid>
<description>Desc2</description>
<dateofmfg>2004-08-05</dateofmfg>
<itemprice>300.0000</itemprice>
</Table>
</NewDataSet>

Required output file:

<?xml version="1.0"?>
<root>
<header value="54">
<productManufacturer manufid="1" manufname="Manuf1" headOffice="HO1">
<productType productid="1" description="Desc1">
<productItem>
<item dateOfMfg="08/01/2004" price="300" />
<item dateOfMfg="08/15/2004" price="300" />
<item dateOfMfg="08/15/2004" price="310" />
</productItem>
</productType>
<productType productid="2" description="Desc2">
<productItem>
<item dateOfMfg="08/01/2004" price="300" />
<item dateOfMfg="08/15/2004" price="300" />
<item dateOfMfg="08/15/2004" price="310" />
</productItem>
</productType>
</productManufacturer>
</header>
</root>

Thanks in advance,

Kalyani
Posttop
(Deleted User) Subject: Transform a XML file with simple type nodes to complex type nodes
Author: (Deleted User)
Date: 05 Apr 2005 11:24 AM
your tansformation is basically a grouping issue, you need to group on manufacture id
for the transformation.It is not very straight forward in XSLT 1, you need to create
a nodeset contains unique element first, then iterate on this nodeset to
do further transformation. It is much easier to do grouping in XSLT 2 using xsl:for-each-group.
Stylus Studio support both XSLT 1 and XSLT 2.

In the past, we have many people ask simmilar question in this forum, if you
search 'grouping' here, you will find some interesting thread that could help
you with your task.

Let me know if you need further help.

song.
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.