Biztalk maps: Grouping different nodes into a list

Posted by pablocastilla on Stack Overflow See other posts from Stack Overflow or by pablocastilla
Published on 2010-04-16T16:01:51Z Indexed on 2010/04/20 14:33 UTC
Read the original article Hit count: 323

Filed under:

BizTalk

|

biztalk-mapper

|

Xml

|

xml-transform

Hello,

Is there a way of achieve the following transformation in the BT mapper? if not, any smart idea?

<Person>
<Age>25</Age>
<Name>Paul</Name>
</Person>

to:

<Person>
<CustomProperties>
<CustomProperty>
<Name>Age</Name>
<Value>25</VAlue>
</CustomProperty>
<CustomProperty>
<Name>Name</Name>
<Value>Paul</VAlue>
</CustomProperty>
</CustomProperties>

I have to aggregate a few elements in a list of nodes.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about BizTalk

Future of BizTalk

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
The future of BizTalk- The last TechEd Conference was a very important one from BizTalk perspective. Microsoft will continue innovating BizTalk and releasing BizTalk versions for “for next few years to come”. So, all the investments that clients have made so far will continue giving returns. Three… >>> More
BizTalk Server Monitoring – SharePoint Web Part

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I have been worked with customers using BizTalk as shared infrastructure in the enterprise, where we have two or more BizTalk apps running on it for different Business groups. Also these customers are not using BizTalk ESB portal even though they are using BizTalk ESB exception framework. So main… >>> More
Useful Tips for BizTalk 2006 to BizTalk 2009 Porting

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
BizTalk projects require some manual intervention in order to upgrade them. Execute the following steps to port a BizTalk solution / project: Open the project’s solution file (.sln) using a text editor – NotePad++ is recommended. Remove all the contents (in red below) between (not including)… >>> More
TFS - How much nesting on disk structure

as seen on Stack Overflow - Search for 'Stack Overflow'
We just got TFS installed and ready go. I'm trying to decide on the disk structure. Let's suppose I have two BizTalk projects called Common and BookTransfer (in actuality I have 7). [At this client, we adopted the style of having schemas, orchs, maps in one project called BizTalk.Artifacts]. A folder… >>> More
BizTalk Server 2009 - Architecture Options

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I recently needed to put forward a proposal for a BizTalk 2009 implementation and as a part of this needed to describe some of the basic architecture options available for consideration. While I already had an idea of the type of environment that I would be looking to recommend, I felt that presenting… >>> More

Related posts about biztalk-mapper

Biztalk mapper: how to detect a node that do not come in the xml

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I would like to know how to detect that a node is not present in the origin. I have tried hundreds of things with the logical functoids with no success. The third case of this page is what I am looking for: http://danshultz.blogspot.com/2007/08/logical-existence-isnil-empty-string.html Thanks… >>> More
Automatically truncate to MaxLength during mapping

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a schema that has the max length property set on all of its elements, of various size. I am mapping to it and expect that the max length will be exceeded quite often. Is there a way tell BizTalk to automatically truncate without having to go in and manually configure a functoid for each element… >>> More
Biztalk maps: Grouping different nodes into a list

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, Is there a way of achieve the following transformation in the BT mapper? if not, any smart idea? <Person> <Age>25</Age> <Name>Paul</Name> </Person> to: <Person> <CustomProperties> <CustomProperty> <Name>Age</Name> <Value>25</VAlue> </CustomProperty> <CustomProperty> <Name>Name</Name> <Value>Paul</VAlue> </CustomProperty> </CustomProperties> I… >>> More
XSLT Transforming sequential XML to hierarchical XML

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a requirement to transform a sequential XML node list into a hierarchical, but I run into some XSLT specific knowledge gap. The input XML contains articles, colors and sizes. In the sample below 'Record1' is an article, 'Record2' represents a color and 'Record3' are the sizes. The number of… >>> More
How to replace a multipart message schema in a map without replacing the map

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an orchestration map that maps two source messages into one destination message. When the schema for one of the source messages changes, I was hoping to be able to click on the input message part and select "Replace Schema" to refresh the schema for just the message part affected. Instead… >>> More