CODEWITHSUNDEEP
biztalkbiztalk-mapper
S.Ruscitto
S.Ruscitto

Reputation: 11

BizTalk xml file to a flatfile format

Relatively new to BizTalk; I could use seasoned help.

I'm faced with having to try to map a source XML document to a flat-file TAB delimited destination. My source document has some nested nodes that I need to iterate through and translate them each as a row on the flat-file document; classic sales order header/detail relationship. The results would need me to repeat the header information for every nested element in the child node.

I've tried a solution using a looping functoid but I'm not sure how to represent the destination list correctly. Am I missing the obvious? At what destination row element should I link my "Looping" output param to?

For demonstration sake here's an example of the schemas I'm working with.

SOURCE SCHEMA (Don't have the possibility to modify the source structure)

DESTINATION SCHEMA

Flat file OUTPUT (One line per detail item)

Anybody could orient me in right direction?

Upvotes: 1

Views: 1432

Answers (1)

AllenG
AllenG

Reputation: 8190

You'll link your Looping Functoid from the source node you want to have generate a new record to (usually) the outer-record node (usually first child of the Root, but not always) of the destination. This will basically tell the map "Every time you see a new blah in my source, create a whole new record in my destination."

Upvotes: 1

Related Questions