I have a FIXED-LENGTH file that looks like this:
- Header line (length=17, occurs=1 time, record id=first 3 chars are HDR)
- Order Header line (length=457, occurs=n times, record id=first 3 chars are 000)
- Order Item line (length=181, occurs=n times for each Order Header line, record id=none)
- Trailer line (length=14, occurs=1 time, record id=first 3 chars are TLR)
Is it possible to design a Flat File Schema for this type of complex structure?