BizTalk Mapping (XML 2 Flat File) Question

[krayan001]

Hi,

Mapping question - I have a hierarchical XML i/p layout that I want to flatten out (to an o/p of delimited/CSV file). The XML layout has optional subtrees. For e.g. in the example below, a department may have zero or many projects and each project may have zero or many employees working on it. This needs to be flattened to have
3 columns separated by comma (i.e. D_Name,P_Name,E_Name)

Example 1: If my i/p XML is like this:
<Department>
<D_Name>IT</D_Name>
<Project>
<P_Name>BizTalk</P_Name>
<Employee>
<E_Name>John Doe</E_Name>
</Employee>
<Employee>
<E_Name>Mark Cuban</E_Name>
</Employee>
</Project>
<Project>
<P_Name>ABC Project - Done</P_Name>
</Project>
</Department>

my output shoule be, (3 records)


IT,BizTalk,John Doe
IT,BizTalk,Mark Cuban
IT,ABC Project - Done,

Example 2: However, if the XML comes like this,
<Department>
<D_Name>IT</D_Name>
</Department>
my output should be, (one record) ==>IT,,

Example 3: Similary, if my i/p is :
<Department>
<D_Name>IT</D_Name>
<Project>
<P_Name>ABC Project - Done</P_Name>
</Project>
</Department>

my output should be, (one record) ==> IT,ABC Project - Done,

Can anyone tell me how/if I can do this using BizTalk mapper ? I created, the CSV schema, and mapped the data from i/p to o/p. The problem is how to tell biztalk of this relationship? I introduced looping functoid
but could not map it at the appropriate level.

Thanks,
Ken