Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

BizTalk Mapping (XML 2 Flat File) Question

BizTalk Mapping (XML 2 Flat File) Question

BizTalk Mapping (XML 2 Flat File) Question


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:
            <E_Name>John Doe</E_Name>
            <E_Name>Mark Cuban</E_Name>    
        <P_Name>ABC Project - Done</P_Name>
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,
my output should be, (one record) ==>IT,,

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

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.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close