BizTalk 2004 Map: Flattening parent child data

Home Page Forums BizTalk 2004 – BizTalk 2010 BizTalk 2004 Map: Flattening parent child data

Viewing 1 reply thread
  • Author
    Posts
    • #17369

      Hi,

       I have the following xml

      <ROOT>
        <PARENTS>
          <PARENT>
            <TAG1>A</TAG1>
            <TAG2>B</TAG2>
            <TAG3>C</TAG3>
          </PARENT>
          <PARENT>
            <TAG1>D</TAG1>
            <TAG2>E</TAG2>
            <TAG3>F</TAG3>
            <CHILDREN>
              <CHILD>
                <TAG1>G</TAG1>
                <TAG2>H</TAG2>
                <TAG3>I</TAG3>
              </CHILD>
              <CHILD>
                <TAG1>J</TAG1>
                <TAG2>K</TAG2>
                <TAG3>L</TAG3>
              </CHILD>
            </CHILDREN>
          </PARENT>
        </PARENTS>
      </ROOT>

      I want to map it to the following

      <ROOT>
        <RECORDS>
          <RECORD>
            <TAG1>A</TAG1>
            <TAG2>B</TAG2>
            <TAG3>C</TAG3>
          </RECORD>
          <RECORD>
            <TAG1>D</TAG1>
            <TAG2>E</TAG2>
            <TAG3>F</TAG3>
          </RECORD>
          <RECORD>
            <TAG1>G</TAG1>
            <TAG2>H</TAG2>
            <TAG3>I</TAG3>
          </RECORD>
          <RECORD>
            <TAG1>J</TAG1>
            <TAG2>K</TAG2>
            <TAG3>L</TAG3>
          </RECORD>
        </RECORDS>
      </ROOT>

      Anyone any idea where I start?

    • #17427

      Have you tried connecting the CHILD record to the the RECORD record with a Loop functoid and then connecting the fields?

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