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

 
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.