Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Create Positional Flat File › Re: Create Positional Flat File
Hi sbrown63,
Don’t forget to change the XML schema if you want to generate more than one instance of member/benefits record:
1. Set the Members node’s Max Occurs property to the unbounded value.
2. Optionally, set the Benefits node’s Max Occurs property to the unbounded value, if you have more than one occurrence of the Benefit record per member.
As for the Positional schema, you can just set the Max Occurs property of the Group node to the unbounded value, and optionally, set the Max Occurs property of the Benefit node to the unbounded value, if you did the same in item 2 above.
Then, in your map, you would use a looping functoid connecting the Members node (in the Xml Schema) to the Group node (in the Positional schema), and map the remaining fields. Additionally, if you used item 2 above, you would use a second-level looping functoid to connect the Benefits node (in the Xml Schema) to the Benefit node (in the Positional schema).
I hope this all makes sense to you…
Daniel.