Re: Create Positional Flat File

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Create Positional Flat File › Re: Create Positional Flat File

August 2, 2010 at 2:48 PM #25479
community-content

    Hi again,   its fours hour later and still no luck. With the above settings I still cannot get the output to include multiple members/benefits in the correct format. I’m starting to get the urge to throw things at my PC. If you could take one more look to see if there is anything obvious I’d greatly appreciate it.

    Flat file results:

    H2_0      H2_0
    Frank  Farmer 
    B1_0   B2_0   
    B5_0   B6_0   
    T1_0

    Flat file expected results:

    H2_0      H2_0
    Frank  Farmer 
    B1_0   B2_0   
    B3_0   B4_0   
    Jim Beam  
    B5_0   B6_0   
    B7_0   B8_0
    T1_0      

    Incoming xml:

    <ns0:Container xmlns:ns0=”http://sbrown63.XmlSchema“>
      <Header>
        <H1>H2_0</H1>
        <H2>H2_0</H2>
      </Header>
      <Members>
        <Member>
          <NameFirst>Frank</NameFirst>
          <NameLast>Farmer</NameLast>
          <Benefits>
            <Benefit>
              <B1>B1_0</B1>
              <B2>B2_0</B2>
            </Benefit>
            <Benefit>
              <B1>B3_0</B1>
              <B2>B4_0</B2>
            </Benefit>
          </Benefits>
        </Member>
        <Member>
          <NameFirst>Jim</NameFirst>
          <NameLast>Beam</NameLast>
          <Benefits>
            <Benefit>
              <B1>B5_0</B1>
              <B2>B6_0</B2>
            </Benefit>
            <Benefit>
              <B1>B7_0</B1>
              <B2>B8_0</B2>
            </Benefit>
          </Benefits>
        </Member>
      </Members>
      <Trailer>
        <T1>T1_0</T1>
      </Trailer>
    </ns0:Container>