Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalk Mapping Help
- This topic has 6 replies, 1 voice, and was last updated 9 years, 3 months ago by
community-content.
-
AuthorPosts
-
-
December 20, 2006 at 10:46 AM #17019
Here is the scenario:
Source:
<Root>
<LOAN>
<Borrower BorrowerLastName="" BorrowerFirstName="" BorrowerMiddleName="" BorrowerSSN="" />…………
</LOAN>
</ROOT>Need Output like this:
when ever Borrower repeats have to generate new Borrower Tag/Attributes with count increase at run time,
<DATA>
<Borrower1 Borrower1LastName="" Borrower1FirstName="" Borrower1MiddleName="" Borrower1SSN=""/>
<Borrower2 Borrower2LastName="" Borrower2FirstName="" Borrower2MiddleName="" Borrower2SSN=""/>…………….there is no limit..every new Borrower count should increase
</DATA>
How it should done.
-
December 20, 2006 at 1:11 PM #17021
not possible.
-
December 20, 2006 at 7:10 PM #17030
Yep, not something the mapper can do. Unless you have a max number of nodes to count up to.
You’ll need to look at using some .net code or something like that to build your message.
-
December 21, 2006 at 5:55 AM #17044
Thanks for your time.
Inline XSLT or XSLT also can't do this???
-
December 22, 2006 at 5:39 AM #17058
Well… XSLT itself can do this. Just the mapper will probably not allow it since you’ll not be matching the output schema you have defined…
Here are two possible ways. I don’t remember off hand what level of validation the mapper does on the document.
- You might be able to use XSLT and output your result to the <ANY> node.
- Use pure custom XSLT for the whole map. You’ll probably also have to use the <Any> node in your schema so you can set an output message type.
Just some ideas to try.
-
January 2, 2007 at 11:56 AM #17105
In this case, I would write a VB app to write the file… 🙂
-
January 9, 2007 at 8:41 AM #17167
What about:
<DATA>
<Borrower id=1 LastName="" FirstName="" MiddleName="" SSN=""/>
<Borrower id=2 LastName="" FirstName="" MiddleName="" SSN=""/>
…
</DATA>- Sometimes I like to ask: Why are you doing it this way?
-
-
-
-
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.