Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sequence of records in an output flat file

Status
Not open for further replies.

flo23

Technical User
Jul 25, 2003
1
DE
Hello everybody,

I've got a problem with the sequence of the records in a
flat file. I've got the following definition of the flat
file (this is how it would look in XML, not the native
instance!):

< order >
< record1 >
< field1/ >
< field2/ >
...
< /record1 >
< record2 >
< field1/ >
< field2/ >
...
< /record2 >
< /order >

Everything works fine, the native instance is ok _except_
for the order of the output _records_. If I have more then
one input record, the whole set of output records should be
created (that is that for every input record one <record1>.
... and then one <record2>... should be created). That is
working also correctly, except for the sequence of it.
BizTalk first creates ALL <record1> lines and after that
all <record2> lines. So the XML instance would look like
the following:

< order >
< record1 >
...
< /record1 >
< record1 >
...
< /record1 >
.
.
.
< record2 >
...
< /record2 >
< record2 >
...
< /record2 >
.
.
.
< /order >

How can I tell BizTalk to avoid that and process both first
for every input line (so that it looks like the definition,
first <record1> then <record2> and that for every input
record) so that it looks like this:

< order >
< record1 >
...
< /record1 >
< record2 >
...
< /record2 >
< record1 >
...
< /record1 >
< record2 >
...
< /record2 >
.
.
.
< /order >


Thanks in advance for your time and help.

Bye,
Flo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top