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 » Stylus Studio Technical Forum » XML to Flat File
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + XXX maps to XXX system (3)
-> + Help with extracting bookmarks... (2)
-> + Stylus Studio crashes when sou... (2)
-> + WSDL not Displaying properly (5)
-> + How to use fonts other than ba... (5)
-> + Saxon XSLT2 and FOP for XSL:FO... (3)
-> + Converting from XML to EDIFACT (5)
-> + Looping more than one time thr... (2)
-> - Need help with using XQuery in... (1)
-> + Looping - Taking the comma out (3)
-> + xslt mapper is only processing... (4)
-> - Newbie: using Saxon 9.1 with F... (1)
-> + Editing ![CDATA[]]> in the Gr... (2)
-> + Convertic EDI files into XML (7)
-> + Type2 Authentication missing D... (6)
-> + Please help in a simple conver... (5)
-> + Doc/Literal Wrapped (4)
-> + Error starting Stylus Studio (9)
-> + WYSIWYG Menu Bar and Tab Missi... (2)
-> + XML file size limits (2)
-> + XML Publisher (2)
-> + cant get namespace declaration... (5)
-> + Fixed Width to XML (3)
-> - file to xml conversion (1)
-> + Create Multiple Page (3)
-> + Flat file conversion with colu... (3)
-> + New Line character problem in ... (2)
-> + need help - stylus doesn't sta... (2)
-> + command line StylusValidator ... (3)
-> + Help unistalling (2)
-> + recurse problem analysis (3)
-> - Newbie: WSAD and file paths (1)
-> - Stylus StudioŽ 2009 XML Enterp... (1)
-> + Help with XSL to transform two... (4)
-> + connect to xhive (2)
-> - element id and name attributes... (1)
-> - http://www.w3.org/2001/XMLSche... (1)
-> + Error message when converting ... (2)
-> + XML id and anyuri datatype (2)
-> - import xml into an ms acces... (1)
-> + Change version (6)
-> + Translate two files into one (3)
-> + invalid relative uri with data... (7)
-> + My table crashes java Runtime (5)
-> + inx to pdf (3)
-> + XSD - multiple similar namespa... (7)
-> + validating many xml files (4)
-> + Stylesheet Parameters (3)
-> + create web service using Stylu... (2)
-> + connect with sql server (4)
-> + License could not be validated... (2)
-> + How to open (or decompress) a ... (3)
-> + Stylus Studio 2009 Home & Java (4)
-> + Connect to Informix DB 7.31.FD... (2)
-> + Unable to download stylus stud... (5)
-> + conversion CSV to XML (2)
-> + Please help to create a XSL to... (2)
-> + Stylus Studio 2009 unresponsiv... (3)
-> + Stylus Studio 2009 and IBM Jav... (2)
-> + separate one record to two lin... (3)
-> + error when running xquery comm... (6)
-> + Convert ebcdic-cp-us to utf-8 (8)
-> - hi urgent plz (1)
-> + Java compile problem (7)
-> + How to set pattern match on th... (3)
-> + Adobe Illustrator CS4 xml not ... (3)
-> + validating XSD with W3c stand... (2)
-> + Count function with condition ... (2)
-> + [Context] variable (4)
-> + Batch process HTML to XML docu... (2)
-> + Need help with adding logiic ... (2)
-> - BUG when editing File Types (1)
-> + Is Stylus Studio XML authoring... (2)
-> + Missing Xpath Query Editor (8)
-> + Error Connecting to DB2 9.5 (3)
-> - Tony (1)
-> + Problem trying to use your sof... (2)
-> + cannot save or associate a sch... (2)
-> + xsd to dtd (2)
-> + Can we use Stylus for our proj... (4)
-> + printing a parent node value i... (2)
-> + How to tell StylusDiff.exe to ... (4)
-> + Pipeline Messages not Consiten... (2)
-> + Custom XML conversion (2)
-> + Format date fields (3)
-> + Can't Connect to iSeries via I... (11)
-> + "application failed to start" ... (5)
-> - Can't connect to an Access DB ... (1)
-> + Unable to attach external JVM (3)
-> + Adding Numbers using XSLT (2)
-> + copy all elements and hardcode... (2)
-> + A bit confused on where to sta... (2)
-> + Application Menu Problem (14)
-> + API to retrieve 'Adapter URL' ... (2)
-> + How do I move my Stylus Studio... (6)
-> + API to retrieve 'Adapter URL' ... (2)
-> + InterPage Linking Problem in .... (2)
-> + xsl - header only once in fore... (7)
-> + StylusDiff.exe crashes when co... (5)
-> + Validation against schemas wan... (5)
-- Previous [781-800] [801-820] [821-840] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Myke GallacherSubject: XML to Flat File
Author: Myke Gallacher
Date: 09 Dec 2008 01:09 AM
I am converting an XML doc to flat file comma seperator (CSV).

I can concatenate the values ok, with the result set looking fine but the doc only returns 1 row?? any pointers?
Postnext
(Deleted User) Subject: XML to Flat File
Author: (Deleted User)
Date: 09 Dec 2008 02:55 AM
Hi Myke,
can you show us the source XML and the XSLT you wrote?

Thanks,
Alberto
Postnext
Myke GallacherSubject: XML to Flat File
Author: Myke Gallacher
Date: 09 Dec 2008 02:45 PM
as you may gather I am a complete rookie at XML
Postnext
Myke GallacherSubject: XML to Flat File
Author: Myke Gallacher
Date: 09 Dec 2008 02:43 PM
XSLT

<?xml version='1.0' ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns="http://www.xxxx.xxx.uk/DataStandards/XMLschema/CDS/ns">
<xsl:template match="/">
<XML_FLAT>
<xsl:for-each select="concat(concat(ns:CDS-XMLInterchange/ns:CDSInterchangeHeader/ns:CDSInterchangeSenderIdentity,',',
ns:CDS-XMLInterchange/ns:CDSInterchangeHeader/ns:CDSInterchangeReceiverIdentity,',',
ns:CDS-XMLInterchange/ns:CDSInterchangeHeader/ns:CDSInterchangeControlReference,',',
ns:CDS-XMLInterchange/ns:CDSInterchangeHeader/ns:CDSInterchangeDateOfPreparation,',',
ns:CDS-XMLInterchange/ns:CDSInterchangeHeader/ns:CDSInterchangeTimeOfPreparation,',',
ns:CDS-XMLInterchange/ns:CDSInterchangeHeader/ns:CDSInterchangeApplicationReference),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/@CDSProtocolIdentifier,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/@CDSType),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSMessageHeader/ns:CDSMessageType,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSMessageHeader/ns:CDSMessageVersionNumber,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSMessageHeader/ns:CDSMessageReferenceNumber,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSMessageHeader/ns:CDSMessageRecordIdentifier),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:CDSType,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:CDSProtocolIdentifier,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:CDSUniqueIdentifier,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:CDSUpdateType,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:CDSApplicableDate,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:CDSApplicableTime,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:CDSActivityDate,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:OrganisationCode_CDSSenderIdentity,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSTransactionHeader_NetChange/ns:OrganisationCode_CDSPrimeRecipientIdentity),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:LocalPatientIdentifier,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:OrganisationCode_LocalPatientIdentifier),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:UnvalidatedNHSNo_Structure/@UnvalidatedNHSNumberStatusIndicator,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:UnvalidatedNHSNo_Structure/ns:NHSNumber,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:UnvalidatedNHSNo_Structure/ns:NHSNumberStatusIndicator,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:UnvalidatedNHSNo_Structure/ns:PostcodeOfUsualAddress,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:UnvalidatedNHSNo_Structure/ns:OrganisationCode_PCTOfResidence),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:ValidatedNHSNo_Structure/@ValidatedNHSNumberStatusIndicator,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:ValidatedNHSNo_Structure/ns:NHSNumber,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:ValidatedNHSNo_Structure/ns:NHSNumberStatusIndicator,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:ValidatedNHSNo_Structure/ns:PostcodeOfUsualAddress,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientIdentity_General_Structure/ns:ValidatedNHSNo_Structure/ns:OrganisationCode_PCTOfResidence),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientCharacteristics_AAndE_Structure/ns:PersonBirthDate,',',
ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientCharacteristics_AAndE_Structure/ns:PersonGenderCurrent,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:PersonGroupPatient_AAndE_Structure/ns:PatientCharacteristics_AAndE_Structure/ns:CarerSupportIndicator),',',
concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:GPRegistration/ns:GMP_CodeOfRegisteredOrReferringGMP,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:GPRegistration/ns:CodeOfGPPractice_RegisteredGMP),',',

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEArrivalMode,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEAttendanceCategory,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEAttendanceDisposal,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEIncidentLocationType,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:SourceOfReferralForAAndE,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEDepartmentType,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:ArrivalDate,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:ArrivalTime,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AgeAtCDSActivityDate,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEInitialAssessmentTime,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndETimeSeenForTreatment,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEDepartureTime,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:AAndEPatientGroup,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:HealthcareResourceGroupCode,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ActivityCharacteristics/ns:HealthcareResourceGroupCode_VersionNumber),',',

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ServiceAgreementDetails/ns:CommissioningSerialNumber,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ServiceAgreementDetails/ns:ProviderReferenceNumber,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ServiceAgreementDetails/ns:OrganisationCode_CodeOfProvider,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ServiceAgreementDetails/ns:OrganisationCode_CodeOfCommissioner),',',

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:PersonGroupAAndEConsultant/ns:AAndEStaffMemberCode,','),

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalInvestigationDetails/ns:ClinicalInvestigationGroupAAndE/ns:InvestigationSchemeInUse,','),

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalInvestigationDetails/ns:ClinicalInvestigationGroupAAndE/ns:PrimaryInvestigationGroupAAndE/ns:PrimaryInvestigation_AAndE,','),

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalInvestigationDetails/ns:ClinicalInvestigationGroupAAndE/ns:SecondaryInvestigationGroupAAndE/ns:SecondaryInvestigation_AAndE,','),

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalTreatmentDetails/ns:ClinicalTreatmentGroupAandE/ns:ProcedureSchemeInUse,','),

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalTreatmentDetails/ns:ClinicalTreatmentGroupAandE/ns:PrimaryTreatmentGroupAAndE/ns:PrimaryTreatment_AAndE,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalTreatmentDetails/ns:ClinicalTreatmentGroupAandE/ns:PrimaryTreatmentGroupAAndE/ns:ProcedureDate,','),

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalTreatmentDetails/ns:ClinicalTreatmentGroupAandE/ns:SecondaryTreatmentGroupAAndE/ns:SecondaryTreatment_AAndE,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:AttendanceOccurrence/ns:ClinicalTreatmentDetails/ns:ClinicalTreatmentGroupAandE/ns:SecondaryTreatmentGroupAAndE/ns:ProcedureDate),',',

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEArrivalMode,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEAttendanceCategory,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEAttendanceDisposal,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEIncidentLocationType,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:SourceOfReferralForAAndE,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEDepartmentType,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:ArrivalDate,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:ArrivalTime,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AgeAtCDSActivityDate,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEInitialAssessmentTime,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndETimeSeenForTreatment,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEDepartureTime,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:AAndEPatientGroup,'',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:HealthcareResourceGroupCode,',',ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ActivityCharacteristics/ns:HealthcareResourceGroupCode_VersionNumber),',',

concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:AccidentAndEmergencyAttendance/ns:HealthcareResourceGroupActivity/ns:ClinicalActivityGroup,''),'',concat(ns:CDS-XMLInterchange/ns:CDSNetChange-All-MessageTypes/ns:CDSMessageTrailer/ns:CDSMessageReferenceNumber,','),

concat(ns:CDS-XMLInterchange/ns:CDSInterchangeTrailer/ns:CDSInterchangeControlReference,',',ns:CDS-XMLInterchange/ns:CDSInterchangeTrailer/ns:CDSInterchangeControlCount,',',ns:CDS-XMLInterchange/ns:CDSInterchangeTrailer/ns:CDSInterchangeSenderIdentity,',',ns:CDS-XMLInterchange/ns:CDSInterchangeTrailer/ns:CDSInterchangeReceiverIdentity))"/>
</XML_FLAT>
</xsl:template>
</xsl:stylesheet>

Posttop
(Deleted User) Subject: XML to Flat File
Author: (Deleted User)
Date: 09 Dec 2008 03:53 PM
Hi Myke,
can you attach also the XML document? Given the names of the field used in the XSLT stylesheet, it's not clear which one are the repetitions.
Can you also add a sample of how the output should look like for that specific instance of XML?

Alberto
   
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.