Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Flat file question
- This topic has 1 reply, 1 voice, and was last updated 9 years, 2 months ago by
community-content.
-
AuthorPosts
-
-
February 13, 2006 at 3:49 PM #12895
A flat file format is like one check record followed by many transaction records and re-occurred as a group. The question is how to correctly manage transaction and check record relationship and eventually parse into a schema that a single check record and all the transaction records that between the two check record lines contained in the same request
A sample flat file
C,check record 1,500
D,transaction 1, 200
D,transaction 2, 300
C,check record 2,600
D,transaction 1, 600
C,check record 3,700
D,transaction 1, 200
D,transaction 2, 300
D,transaction 3, 200the schema to processed as
<Requests>
<Request>
<Check>
<CheckRecord>check record 1</CheckRecord>
<Amount>500</Amount>
</Check>
<Transaction>
<TransactionRecord>transaction 1</TransactionRecord>
<Amount>300</Amount>
</Transaction>
<Transaction>
<TransactionRecord>transaction 2</TransactionRecord>
<Amount>200</Amount>
</Transaction>
</Request>
<Request>
<Check>
<CheckRecord>check record 2</CheckRecord>
<Amount>600</Amount>
</Check>
<Transaction>
<TransactionRecord>transaction 1</TransactionRecord>
<Amount>600</Amount>
</Transaction>
</Request>
<Request>
<Check>
<CheckRecord>check record 3</CheckRecord>
<Amount>700</Amount>
</Check>
<Transaction>
<TransactionRecord>transaction 1</TransactionRecord>
<Amount>200</Amount>
</Transaction>
<Transaction>
<TransactionRecord>transaction 2</TransactionRecord>
<Amount>300</Amount>
</Transaction>
<Transaction>
<TransactionRecord>transaction 3</TransactionRecord>
<Amount>200</Amount>
</Transaction>
</Request>
</Requests> -
February 14, 2006 at 6:16 AM #12896
You can have a look at the video by Stephen which is about flat files and also contains the solution for your problem…(use all-in-one schema)
The video is available at http://www.biztalkgurus.com/Video/Flat-File-Disassembler-Video.html
Thanks to Stephen for such great work!
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.