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 » Need Help defining Flat File with nested repeating fields.
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + StylusValidator.exe Command Li... (3)
-> + Cannot run Java built in valid... (2)
-> + Windows 10??? (3)
-> + Stylus Custom XML Conversion (... (8)
-> + X14 enterprise and saxon 9.4.0... (3)
-> + Open an XML document in the XM... (3)
-> + How to generate mapping report... (4)
-> + Unresponsive - Custom XML Conv... (2)
-> - Need Help defining Flat File w... (1)
-> + XML to Database (6)
-> + XSD path when associating to a... (3)
-> - Auto EDI File Translation (1)
-> + Need help parsing EDI and crea... (2)
-> + Bug in generating Xml from Dtd (7)
-> + Stylus Studio 15, install erro... (4)
-> + How to create UML from XSD (2)
-> + Java configuration (4)
-> + embedding/starting X15 dircet ... (2)
-> + Stylus X15 R2 environment crip... (5)
-> + Output Method TEXT does not wo... (6)
-- Previous [121-140] [141-160] [161-180] 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  
Posttop
Clarice OgburnSubject: Need Help defining Flat File with nested repeating fields.
Author: Clarice Ogburn
Date: 23 Mar 2015 08:14 PM
Originally Posted: 23 Mar 2015 08:03 PM
I'm new to the DataDirect tool and needed some guidance on how to define this flat file with fixed width records. You can't tell with the editting tool here but the C0, D0, E0, F0 records are all nested under the Batch level. D0, E0 , and F0 are nested under the C0 -- claim level.

Here is an outline structure:
A0 ------ File Level
AA
AB
B0-------Batch Level
BA
BB
C0---- Claim Level --- repeats (5000)
CA
D0 -- Payer --- repeats (11)
D1 --
E0
E5
E6 ----Provider Level -- repeats (6)

I will also attach a deIdentified Claim file. When I initially defined this, I just used a regex expression to read each record type. However, when I started mapping in the XSLT mapper, realized that this would not work. I need to be able to define each level and the repeating for each level. Please advise.


DocumentPCDSDeIdTestFile.dat
DeIdentified Claim File Example
   
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.