Biztalk xml file to a flatfile format

Question

Hi,

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 delimted 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)

• schema\
• salesorders\
• salesorders\orders\
• orders\soid
• orders\cust name
• orders\address
• orders\detail\
• orders\detail\msrp
• orders\detail\modelno
• orders\detail\sku

DESTINATION SCHEMA

• schema\
• \root\
• soid
• custname
• address
• etc...

Flat file OUTPUT (One line per detail item)

• soid custname address msrp modelno sku
• soid custname address msrp modelno sku

Anybody could orient me in right direction?

Much appreciated!

Answer 1

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."