How to turn a single record into multiple in Biztalk mapping?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to turn a single record into multiple in Biztalk mapping?

Viewing 1 reply thread
  • Author
    Posts
    • #22277

      Hi, I have an inssue while I am mapping a single record into multiple records.

      When I say a single record, it is really a single record which containing a string.

      For example,

      <Doc>

      <MyOnlyRecord>John,Sam,Peter,Robert</MyOnlyRecord>

      </Doc>

      I want to turn the above into,

      <Doc>

      <Records>

          <Name>John</Name>

          <Name>Sam</Name>

          <Name>Peter</Name>

          <Name>Robert</Name>

      </Records>

      </Doc>

       

      So, I’ve got a comma delimited string as an input and turn them into multiple records in Biztalk Mapping.

      I’ve looked at inline call XSLT, inline C# with the scripting functoids, but I couldn’t figure out how exactly…

       

      Please help,!!

       

      Thanks heaps in advance all the GURUS!!

    • #22281

      Hi,

      This http://www.stylusstudio.com/xsllist/200312/post30300.html tutorial can help you. Read  it carefully, and just suite for your schemas and field names.

      Use scripting functoid, else you can write external assembly and call it from your map.

      Good luck.

       

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