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