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
Conferences Close Tree View
+ Stylus Studio Feature Requests (1169)
- Stylus Studio Technical Forum (14438)
-> + SXXP0003: Error reported by XM... (2)
-> + Validation error (5)
-> + Windows 10, latest Java, new t... (2)
-> + using help crashes stylus stud... (3)
-> + Web Service Call error (5)
-> + javax.xml.xquery.XQException: ... (2)
-> + Trang translator is not availa... (2)
-> + Replacement for flat2xml (2)
-> + CONV CSV Display Problem (3)
-> + 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)
-- Previous [61-80] [81-100] [101-120] Next
+ Website Feedback (244)
+ XSLT Help and Discussion (7593)
+ XQuery Help and Discussion (1941)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (363)
+ 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.