fixed lenght flat file to list of IS Documents using flatfile.converttovalues

, ,
1

The fixed file has repeating data structure. For example,
Header 111userCompany
Transaction1
Transaction2
Footer 111userCompany
Header 222userCompany
Transaction1
Transaction2
Footer 222userCompany

I have created a flat file schema and a corresponding IS Document from that flat file schema.

FlatFile.ConvertToValues method just returns me a single document That has just this…
Header 111userCompany
Transaction1
Transaction2
Footer 111userCompany

I expect to get list of documents so in this case 2 IS documents.
Note: I have thought about spitting the flat file before consuming it but I am looking for a WM solution.

Thanks

2

change max repeat to " Unlimited" you will get multiple records

3

Thanks for response. I have three document each for header, transaction, and footer. I need to have that in exact sequence. So final document contains (header, transactions, and footer documents). Something like this
FinalISDocument1
Header
Transactions
Transaction1
Transaction2…
Footer
FinalISDocument2
Header
Transactions
Transaction1
Transaction2…
Footer

Just by setting that property to unlimited gives me flat collection of headers, trnasactions, and footers. I guess I need to restructure my documents differently.

4

Yes you need to restructure your FF Schema structure and what ever needs repeated needs unlimited property on the particular node (IDATA) as documentList

HTH,
RMG