Subject: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.