XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Posttop
Dwayne BordelonSubject: Need help with using XQuery in Stylus Studio to convert and transform flat file to xml
Author: Dwayne Bordelon
Date: 17 Apr 2009 09:34 AM
I have a tilde delimited file that I need to convert to an xml file. I have the initial conversion step done(an exact representation, just in xml) and some of the more complicated conversion(representing the 1 to many relationships) done with xquery. I am stuck with removing duplicates. The source file(tilde delimited) can have repeating rows of customer information because there are two levels of information in the file. I am getting a result with the right representation, but I cannot keep it from repeating the customer info based on how many times it shows up in source file.


Unknowndropletter(1).prj
The project

Unknowncustomer(2).xml
the source file

Unknowndropletter(1).conv
the conversion file

UnknownSales_Drop_Letter(1).xml
destination supposed to look like this

UnknownSales_Drop_Letter(1).xsd
destination schema

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.