I am mapping from xml to a flat file

xml schema
<subscriber>               flatfile schema
<person>                   lastname
<lastname>               firstname
<firstname>
<dependent>
<person>
<lastname>
<firstname>

There will be many subscribers, and each subscriber can have
zero or more dependents. Each separate person, whether it is a
subscriber or one of his dependents, will generate its own flat file
record. In typical programming terms, this would call for an outer
loop of subscribers with an inner loop of dependents.

Example XML
<subscriber>
<person>
<lastname>Smith</lastname>
<firstname>John</Corcoran>
</person>
<dependent>
<person>
<lastname>Smith</lastname>
<firstname>Joan</Corcoran>
</person>
</dependent>
<dependent>
<person>
<lastname>Smith</lastname>
<firstname>Jimmy</Corcoran>
</person
</dependent>
</subscriber>

would produce this flat file
Smith John
Smith Joan
Smith Jimmy

Is it possible to configure nested loops with the looping functoid?
One of the issues, from a mapping perspective, would be two outputs
targeting the lastName node in the flat file schema, for example.

Thanks,
Bob Corcoran

[ Post a follow-up to this message ]

Try the following:
1) Add a looping functoid and connect the source subscriber/person and the
subsciber/dependent/person nodes to it.  Then link the functoid to the
destination parent record for lastname and firstname.
2) Link the source subscriber/person/lastname to the destiniation lastname
3) Link the source subscriber/person/firstname to the destiniation firstname
4) Link the source subscriber/dependent/person/lastname  to the
destiniation lastname
5) Link the source subscriber/dependent/person/firstname to the
destiniation firstname

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------[vbcol=seagreen] 
cpmsftngxa10.phx.gbl!TK2MSFTNGXA06.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGXA03.phx.gbl[vbcol=seagreen] 

[ Post a follow-up to this message ]