BizTalk Server General - Repeating Source Nodes to destination.

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > December 2005 > Repeating Source Nodes to destination.





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Repeating Source Nodes to destination.
vishal

2005-12-09, 2:50 am

Hello All,
I am trying to parse a flatfile which has some repeating nodes.
The output that I am getting looks like this....
- <DETAIL>
- <PAY>
<InvoiceNo>1161660</InvoiceNo>
<InvoiceNo>1169930</InvoiceNo>
<InvoiceAmount>912.64</InvoiceAmount>
<InvoiceAmount>627.65</InvoiceAmount>
</PAY>
- <MSG>
<InvoiceNo>1161660</InvoiceNo>
<InvoiceNo>1169930</InvoiceNo>
<Msg>Invoice was accepted.</Msg>
<Msg>Invoice was accepted.</Msg>
</MSG>
</DETAIL>
Instead I would like to get an output which looks like .....
- <DETAIL>
- <PAY>
<InvoiceNo>1161660</InvoiceNo>
<InvoiceAmount>912.64</InvoiceAmount>
</PAY>
- <MSG>
<InvoiceNo>1161660</InvoiceNo>
<Message>Invoice was accepted.</Message>
</MSG>
- <PAY>
<InvoiceNo>1169930</InvoiceNo>
<InvoiceAmount>627.65</InvoiceAmount>
</PAY>
- <MSG>
<InvoiceNo>1169930</InvoiceNo>
<Message>Invoice was accepted.</Message>
</MSG>
</DETAIL>

In my map , my source schema has a sequence node which is making multiple
attributes for PAY & MSG.
As of now the destination schema has a detail node and PAY & MSG inside it
with maxoccurs to unbounded.

Do I need a functoid to for this transformation or I need to set any
property correctly.

Let me know... as it urgent..

Vishal.
Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com