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)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ 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.