×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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 Server 2002 Mapping question regarding duplicate data

BizTalk Server 2002 Mapping question regarding duplicate data

BizTalk Server 2002 Mapping question regarding duplicate data

(OP)
Hey dudes. I'm fairly new to BizTalk and development in general, but very strong in VBScript so the Mapper is pretty comfortable to me. On to my question...

I have a source XML document that has an element which maps to an XML attribute at the destination. On the source side there are several occurences of this element with the same value. Also, the source side is fairly flat. I want to build a hierarchy on the destination side by only creating a single instance of this attribute based on that value.

In other words if element1 has a specific value that occurs 10 times, I want it only to occur ONCE in the destination.

I looked at the looping functoid, but it seems that's only useful in the case where there are greater than 1 source elements (meaning two inputs). I also did some wacky stuff with VBScript in a custom functoid that involved a dictionary object to store the values, then map them after the fact. This all seemed to be way too much, so I opted to pull this solution out of the Mapper and put it into a .NET AIC (which uses HashTables to store the values and build the hierarchy in memory before producing the resulting XML).

Anyone else run into this problem? If so, how did you solve it? Thanks!

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