BizTalk XML mapping query

Home Page Forums BizTalk 2004 – BizTalk 2010 BizTalk XML mapping query

Viewing 1 reply thread
  • Author
    Posts
    • #22626

      Hello. I’ve got a problem whereby I’m attempting to map a well-formed, but not particularly useful, XML file into another more useful one.

      Example source XML:

      <table>
        <row>
          <column>101000041468</column>
          <column>Environment – Graffiti Incident</column>
          <column>Mr Joe Bloggs</column>
          <column>Environment</column>
          <column>Street Cleansing</column>
          <column>Graffiti</column>
          <column>1</column>
          <column>12 May 09</column>
        </row>
        <row>…</row>
        <row>…</row>
      </table>

      Appears in BizTalk schema designer as:

      table
        row
          column

      Example output desired:

      <ns0:Root xmlns:ns0=”http://graffiti_final“>
        <Case>
          <Reference>101000041468</Reference> 
          <Title>Environment – Graffiti Incident</Title> 
          <Associated>Mr Joe Bloggs</Associated> 
          <Subject>Environment</Subject> 
          <Reason>Street Cleansing</Reason> 
          <Type>Graffiti</Type> 
          <Allocation>Graffiti</Allocation> 
          <Status>1</Status> 
          <Created>12 May 09</Created>
        </Case>
        <Case>…</Case>
      </ns0:Root>

      Appears in schema designer as:

      Root
        Case
          Reference
          Title
          Associated
          Subject
          Reason
          Type
          Allocation
          Status
          Created

      I’ve tried using the Index functoid, which I managed to get to work but only for the first instance of row in the source xml.  I couldn’t see a way to feed a loop into Index so looked elsewhere.

      I’ve tried Table Loop/Extractor combo and managed to get it to loop through all rows but only output the Reference into each output column.

      I’m really not all that familiar with figuring this out (obviously) so if anyone has any suggestions or even references I can refer to to aid me in this, that’d be a great help. 

      Thanks in advance.

    • #22627

      Hello, it’s me again.

      I thought I’d reply letting you know that I was missing the Loop Functoid at the start of the mapping (while using the Index functoids).  A bit of a duh moment there.

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