How to implement Group By functionality in Biztalk Map?
-
Monday, March 12, 2012 3:27 PM
I/P is like
<Name>raj<Name><Number>111</Number>
<Account>12345</Account>
<Name>Mohan<Name>
<Number>222</Number>
<Account>23456</Account>
<Name>raj<Name>
<Number>111</Number>
<Account>23456</Account>
output should be
<Name>raj<Name><Number>111</Number>
<Accounts>
<Account>12345</Account>
<Account>23456</Account>
</Accounts>
<Name>Mohan<Name>
<Number>222</Number>
<Accounts>
<Account>23456</Account>
</Accounts>
Please guide me.
Thanks alot
ravindra
- Changed Type Ben Cline1MVP, Moderator Monday, March 12, 2012 5:47 PM asks a question
All Replies
-
Monday, March 12, 2012 5:58 PM
Refer these links
http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2
Thanks, mm2709
- Proposed As Answer by Rohit.SharmaMVP, Moderator Monday, March 12, 2012 6:10 PM
- Marked As Answer by ravi230 Friday, May 04, 2012 6:41 PM
-
Monday, March 12, 2012 8:12 PM
i did this for EDI 837 transactions.
1. the only possible way using Biztalk Map is 'Meunchian method'.
2. Calling .net component which uses XSLT 2.0 ? (never got chance to implement it)
- Marked As Answer by Leonid GanelineMVP, Moderator Tuesday, March 13, 2012 3:02 AM
-
Tuesday, March 13, 2012 3:04 AMModeratorIMO, Xslt is not a good tool to implement grouping. SQL is much better. So if you could move this logic to SQL it would be simpler.
Leonid Ganeline [BizTalk MVP] BizTalkien: Advanced Questions: have fun - test your knowledge

