BizTalk Mapping Help

Home Page Forums BizTalk 2004 – BizTalk 2010 BizTalk Mapping Help

Viewing 1 reply thread
  • Author
    Posts
    • #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.

       

    • #17021

      not possible.

      • #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. 

        • #17044

           

          Thanks for your time. 

          Inline XSLT or XSLT also can't do this???

          • #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.

             

            1. You might be able to use XSLT and output your result to the <ANY> node.
            2. 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.

            • #17105

              In this case, I would write a VB app to write the file… 🙂

              • #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?

                 

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.