Flatfile Schema Creation for Nested Multiple Records

Hi,

There is a requirement to create a Flatfile schema for the following flat file structure; we have SalesRec and Ticket as records which are repeating for multiple times.

Please refer the attached diagram “wmusers.com” for flat file structure.

SalesRec: root level record, unbounded (level 1), Delimited by “|”, for ex: sp123456789000000&17Nov2010&mumbai&delhi&8000&601^kf123456789000000&22Nov2010&delhi&mumbai&5500&602^|

Ticket: child record of SalesRec, unbounded (level 2), Delimited by “^”, for ex: kf123456789000000&22Nov2010&delhi&mumbai&5500&602

DocNo: Field 1, Fields are delimited by “&”
FlightDate: Field 2
and etc

Do we have any option in webMethods Flat File Schema Adapter to create nested multiple records as defined above?

Sample Data:
sp123456789000000&17Nov2010&mumbai&delhi&8000&601^kf123456789000000&22Nov2010&delhi&mumbai&5500&602^|ia12344444400000&12October2010&Delhi&Pune&5000&603^|
sp123456789000000&17Nov2010&mumbai&delhi&8000&604^kf123456789000000&22Nov2010&delhi&mumbai&5500&605^|sp123456789000000&17Nov2010&mumbai&delhi&8000&606^kf123456789000000&22Nov2010&delhi&mumbai&5500&607^|sp123456789000000&17Nov2010&mumbai&delhi&8000&601^kf123456789000000&22Nov2010&delhi&mumbai&5500&608^|sp123456789000000&17Nov2010&mumbai&delhi&8000&609^kf123456789000000&22Nov2010&delhi&mumbai&5500&610^|sp123456789000000&17Nov2010&mumbai&delhi&8000&611^kf123456789000000&22Nov2010&delhi&mumbai&5500&612^|sp123456789000000&17Nov2010&mumbai&delhi&8000&613^kf123456789000000&22Nov2010&delhi&mumbai&5500&614^|sp123456789000000&17Nov2010&mumbai&delhi&8000&615^kf123456789000000&22Nov2010&delhi&mumbai&5500&616^|sp123456789000000&17Nov2010&mumbai&delhi&8000&617^kf123456789000000&22Nov2010&delhi&mumbai&5500&618^|sp123456789000000&17Nov2010&mumbai&delhi&8000&619^kf123456789000000&22Nov2010&delhi&mumbai&5500&620^|

Thanks in advance.
Rajamani Muniappan
salesrec_147.jpg