none
Flat file schema wizard generation output is diferent RRS feed

  • Question

  • Hi all,

    I am trying to create a flat file schema for the sample text but unable to get the desired output.

    Here is my sample text file

    3292015E011985-01-16L9918007NPM4927349999010012008-10-01001250000000012008-10-0100125000000E011985-01-16L9918007NPM4927349999010012008-10-01001250000000012008-10-0100125000000
    4292015E011985-01-16L9918007NPM4927349999010012008-10-01001250000000012008-10-0100125000000E011985-01-16L9918007NPM4927349999010012008-10-01001250000000012008-10-0100125000000

    Please find below the generated xml when I validate using above instance


    <Root xmlns="http://Test">

    <Root_Child1 xmlns=""> <Root_Child1_Child1>3292015</Root_Child1_Child1> <Root_Child1_Child2><Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1> <Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2> <Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3> <Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4> <Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5> <Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6> <Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7> <Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8> <Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9> <Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10> <Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11> <Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12> <Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13> <Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>E01</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>1985-01-16</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>L9918007NPM</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>492</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>7349999010</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>012008-10-0</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>100</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>1250000000</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>012008-10-0</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>100</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>125000000</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>4292015E01</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>198</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>5-01-16L99</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>18007NPM492</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>734</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>9999010012</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>008-10-0100</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>125</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>0000000012</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>008-10-0100</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>125</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>000000E011</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>985-01-16L9</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>918</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>007NPM4927</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>34999901001</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>200</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>8-10-01001</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>25000000001</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>200</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>8-10-01001</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>25000000</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> </Root_Child1_Child2> </Root_Child1> </Root>


    Expected Xml

    <Root xmlns="http://Test">
    <Root_Child1 xmlns="">
    <Root_Child1_Child1>3292015</Root_Child1_Child1>
    <Root_Child1_Child2>
    <Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    <Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    <Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    <Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    <Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    <Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    <Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    <Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    <Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    <Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    <Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    <Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    <Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    <Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    </Root_Child1_Child2>
    <Root_Child1_Child2>
    <Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    <Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    <Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    <Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    <Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    <Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    <Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    <Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    <Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    <Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    <Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    <Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    <Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    <Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    </Root_Child1_Child2>
    
    </Root_Child1>
    <Root_Child1>
    <Root_Child1_Child1>4292015</Root_Child1_Child1>
    <Root_Child1_Child2>
    <Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    <Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    <Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    <Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    <Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    <Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    <Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    <Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    <Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    <Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    <Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    <Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    <Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    <Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    </Root_Child1_Child2>
    <Root_Child1_Child2>
    <Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    <Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    <Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    <Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    <Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    <Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    <Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    <Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    <Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    <Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    <Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    <Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    <Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    <Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15>
    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    </Root_Child1_Child2_Child15>
    </Root_Child1_Child2>
    
    </Root_Child1>
    </Root>

    I am able to generate successfully but not able to validate

    generated xml

    <ns0:Root xmlns:ns0="http://Test">
     <Root_Child1>
      <Root_Child1_Child1>Root_Child1_Child1_0</Root_Child1_Child1> 
    <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
    <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
    <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
      </Root_Child1>
     <Root_Child1>
      <Root_Child1_Child1>Root_Child1_Child1_0</Root_Child1_Child1> 
     <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
     <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
     <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
      </Root_Child1>
     <Root_Child1>
      <Root_Child1_Child1>Root_Child1_Child1_0</Root_Child1_Child1> 
     <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
     <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
     <Root_Child1_Child2>
      <Root_Child1_Child2_Child1>Root_Child1_Child2_Child1_0</Root_Child1_Child2_Child1> 
      <Root_Child1_Child2_Child2>Root_Child1_Child2_Child2_0</Root_Child1_Child2_Child2> 
      <Root_Child1_Child2_Child3>Root_Child1_Child2_Child3_0</Root_Child1_Child2_Child3> 
      <Root_Child1_Child2_Child4>Root_Child1_Child2_Child4_0</Root_Child1_Child2_Child4> 
      <Root_Child1_Child2_Child5>Root_Child1_Child2_Child5_0</Root_Child1_Child2_Child5> 
      <Root_Child1_Child2_Child6>Root_Child1_Child2_Child6_0</Root_Child1_Child2_Child6> 
      <Root_Child1_Child2_Child7>Root_Child1_Child2_Child7_0</Root_Child1_Child2_Child7> 
      <Root_Child1_Child2_Child8>Root_Child1_Child2_Child8_0</Root_Child1_Child2_Child8> 
      <Root_Child1_Child2_Child9>Root_Child1_Child2_Child9_0</Root_Child1_Child2_Child9> 
      <Root_Child1_Child2_Child10>Root_Child1_Child2_Child10_0</Root_Child1_Child2_Child10> 
      <Root_Child1_Child2_Child11>Root_Child1_Child2_Child11_0</Root_Child1_Child2_Child11> 
      <Root_Child1_Child2_Child12>Root_Child1_Child2_Child12_0</Root_Child1_Child2_Child12> 
      <Root_Child1_Child2_Child13>Root_Child1_Child2_Child13_0</Root_Child1_Child2_Child13> 
      <Root_Child1_Child2_Child14>Root_Child1_Child2_Child14_0</Root_Child1_Child2_Child14> 
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
     <Root_Child1_Child2_Child15>
      <Root_Child1_Child2_Child15_Child1>Root_Child1_Child2_Child15_Child1_0</Root_Child1_Child2_Child15_Child1> 
      <Root_Child1_Child2_Child15_Child2>Root_Child1_Child2_Child15_Child2_0</Root_Child1_Child2_Child15_Child2> 
      <Root_Child1_Child2_Child15_Child3>Root_Child1_Child2_Child15_Child3_0</Root_Child1_Child2_Child15_Child3> 
      </Root_Child1_Child2_Child15>
      </Root_Child1_Child2>
      </Root_Child1>
      </ns0:Root>

    My XSD Schema

     <?xml version="1.0" encoding="utf-16" ?> 
    - <xs:schema xmlns="http://Test" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" targetNamespace="http://Test" xmlns:xs="http://www.w3.org/2001/XMLSchema">
    - <xs:annotation>
    - <xs:appinfo>
      <schemaEditorExtension:schemaInfo namespaceAlias="b" extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension" standardName="Flat File" xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions" /> 
      <b:schemaInfo standard="Flat File" codepage="65001" default_pad_char="" pad_char_type="char" count_positions_by_byte="false" parser_optimization="speed" lookahead_depth="3" suppress_empty_nodes="false" generate_empty_nodes="true" allow_early_termination="false" early_terminate_optional_fields="false" allow_message_breakup_of_infix_root="false" compile_parse_tables="false" root_reference="Root" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:element name="Root">
    - <xs:annotation>
    - <xs:appinfo>
      <b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="infix" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:complexType>
    - <xs:sequence>
    - <xs:annotation>
    - <xs:appinfo>
      <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:element minOccurs="0" maxOccurs="unbounded" name="Root_Child1">
    - <xs:annotation>
    - <xs:appinfo>
      <b:recordInfo structure="positional" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:complexType>
    - <xs:sequence>
    - <xs:annotation>
    - <xs:appinfo>
      <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:element name="Root_Child1_Child1" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="7" sequence_number="1" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element minOccurs="0" maxOccurs="unbounded" name="Root_Child1_Child2">
    - <xs:annotation>
    - <xs:appinfo>
      <b:recordInfo structure="positional" sequence_number="2" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:complexType>
    - <xs:sequence>
    - <xs:annotation>
    - <xs:appinfo>
      <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:element name="Root_Child1_Child2_Child1" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="1" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child2" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="2" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child3" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="10" sequence_number="3" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child4" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="6" sequence_number="4" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child5" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="5" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child6" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="6" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child7" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="7" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child8" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="8" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child9" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="9" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child10" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="10" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child11" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="11" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child12" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="12" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child13" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="13" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child14" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="14" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element minOccurs="0" maxOccurs="unbounded" name="Root_Child1_Child2_Child15">
    - <xs:annotation>
    - <xs:appinfo>
      <b:recordInfo structure="positional" sequence_number="15" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:complexType>
    - <xs:sequence>
    - <xs:annotation>
    - <xs:appinfo>
      <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" /> 
      </xs:appinfo>
      </xs:annotation>
    - <xs:element name="Root_Child1_Child2_Child15_Child1" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="1" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child15_Child2" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="10" sequence_number="2" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
    - <xs:element name="Root_Child1_Child2_Child15_Child3" type="xs:string">
    - <xs:annotation>
    - <xs:appinfo>
      <b:fieldInfo justification="left" pos_offset="0" pos_length="11" sequence_number="3" /> 
      </xs:appinfo>
      </xs:annotation>
      </xs:element>
      </xs:sequence>
      </xs:complexType>
      </xs:element>
      </xs:sequence>
      </xs:complexType>
      </xs:element>
      </xs:sequence>
      </xs:complexType>
      </xs:element>
      </xs:sequence>
      </xs:complexType>
      </xs:element>
      </xs:schema>

    Can anyone assist me to generate the expected schema , please?

    Thanks


    Sri

    Wednesday, November 20, 2019 11:29 AM

Answers

  • In that case, you have to define a Tag Identifier on the Root_Child1_Child2 node, remove Root_Child2_Child1 and set the offset to 1 on the Root_Child1_Child2_Child2 rather than changing the Max and Min Occurs.

    <?xml version="1.0" encoding="utf-16"?>
    <xs:schema xmlns="http://Test" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" targetNamespace="http://Test" xmlns:xs="http://www.w3.org/2001/XMLSchema">
      <xs:annotation>
        <xs:appinfo>
          <schemaEditorExtension:schemaInfo namespaceAlias="b" extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension" standardName="Flat File" xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions" />
          <b:schemaInfo standard="Flat File" codepage="65001" pad_char_type="char" count_positions_by_byte="false" parser_optimization="speed" lookahead_depth="3" suppress_empty_nodes="false" generate_empty_nodes="true" allow_early_termination="false" early_terminate_optional_fields="false" allow_message_breakup_of_infix_root="false" compile_parse_tables="false" root_reference="Root" default_pad_char=" " />
        </xs:appinfo>
      </xs:annotation>
      <xs:element name="Root">
        <xs:annotation>
          <xs:appinfo>
            <b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="infix" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
          </xs:appinfo>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <xs:annotation>
              <xs:appinfo>
                <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
              </xs:appinfo>
            </xs:annotation>
            <xs:element minOccurs="0" maxOccurs="unbounded" name="Root_Child1">
              <xs:annotation>
                <xs:appinfo>
                  <b:recordInfo structure="positional" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
                </xs:appinfo>
              </xs:annotation>
              <xs:complexType>
                <xs:sequence>
                  <xs:annotation>
                    <xs:appinfo>
                      <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
                    </xs:appinfo>
                  </xs:annotation>
                  <xs:element name="Root_Child1_Child1" type="xs:string">
                    <xs:annotation>
                      <xs:appinfo>
                        <b:fieldInfo justification="left" pos_offset="0" pos_length="7" sequence_number="1" />
                      </xs:appinfo>
                    </xs:annotation>
                  </xs:element>
                  <xs:element minOccurs="1" maxOccurs="unbounded" name="Root_Child1_Child2">
                    <xs:annotation>
                      <xs:appinfo>
                        <b:recordInfo structure="positional" sequence_number="2" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" tag_name="E" tag_offset="0" />
                      </xs:appinfo>
                    </xs:annotation>
                    <xs:complexType>
                      <xs:sequence>
                        <xs:annotation>
                          <xs:appinfo>
                            <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
                          </xs:appinfo>
                        </xs:annotation>
                        <xs:element name="Root_Child1_Child2_Child2" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="1" pos_length="2" sequence_number="1" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child3" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="10" sequence_number="2" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child4" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="6" sequence_number="3" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child5" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="4" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child6" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="5" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child7" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="6" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child8" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="7" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child9" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="8" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child10" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="9" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child11" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="10" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child12" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="11" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child13" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="12" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child14" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="13" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element minOccurs="0" maxOccurs="unbounded" name="Root_Child1_Child2_Child15">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:recordInfo structure="positional" sequence_number="14" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
                            </xs:appinfo>
                          </xs:annotation>
                          <xs:complexType>
                            <xs:sequence>
                              <xs:annotation>
                                <xs:appinfo>
                                  <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
                                </xs:appinfo>
                              </xs:annotation>
                              <xs:element name="Root_Child1_Child2_Child15_Child1" type="xs:string">
                                <xs:annotation>
                                  <xs:appinfo>
                                    <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="1" />
                                  </xs:appinfo>
                                </xs:annotation>
                              </xs:element>
                              <xs:element name="Root_Child1_Child2_Child15_Child2" type="xs:string">
                                <xs:annotation>
                                  <xs:appinfo>
                                    <b:fieldInfo justification="left" pos_offset="0" pos_length="10" sequence_number="2" />
                                  </xs:appinfo>
                                </xs:annotation>
                              </xs:element>
                              <xs:element name="Root_Child1_Child2_Child15_Child3" type="xs:string">
                                <xs:annotation>
                                  <xs:appinfo>
                                    <b:fieldInfo justification="left" pos_offset="0" pos_length="11" sequence_number="3" />
                                  </xs:appinfo>
                                </xs:annotation>
                              </xs:element>
                            </xs:sequence>
                          </xs:complexType>
                        </xs:element>
                      </xs:sequence>
                    </xs:complexType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:schema>



    • Edited by Colin Dijkgraaf Friday, November 22, 2019 3:14 AM
    • Marked as answer by Sriram27 Tuesday, November 26, 2019 3:24 AM
    Friday, November 22, 2019 3:10 AM

All replies

  • Can you explain how the generated output differs from the expected?
    Wednesday, November 20, 2019 8:14 PM
  • Hello Colin, Generated output xml and expected are same. But when I try to validate against the input text file instance I am getting the below xml which is not expected. I ran through the wizard multiple times not sure why i am not able to get the expected output <Root xmlns="http://Test"> <Root_Child1 xmlns=""> <Root_Child1_Child1>3292015</Root_Child1_Child1> <Root_Child1_Child2><Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1> <Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2> <Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3> <Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4> <Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5> <Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6> <Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7> <Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8> <Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9> <Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10> <Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11> <Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12> <Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13> <Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>E01</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>1985-01-16</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>L9918007NPM</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>492</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>7349999010</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>012008-10-0</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>100</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>1250000000</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>012008-10-0</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>100</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>125000000</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>4292015E01</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>198</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>5-01-16L99</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>18007NPM492</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>734</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>9999010012</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>008-10-0100</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>125</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>0000000012</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>008-10-0100</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>125</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>000000E011</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>985-01-16L9</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>918</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>007NPM4927</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>34999901001</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>200</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>8-10-01001</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>25000000001</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15> <Root_Child1_Child2_Child15_Child1>200</Root_Child1_Child2_Child15_Child1> <Root_Child1_Child2_Child15_Child2>8-10-01001</Root_Child1_Child2_Child15_Child2> <Root_Child1_Child2_Child15_Child3>25000000</Root_Child1_Child2_Child15_Child3> </Root_Child1_Child2_Child15> </Root_Child1_Child2> </Root_Child1> </Root>

    Sri

    Thursday, November 21, 2019 1:57 AM

  • You've tried to have a positional flat file that has multiple levels as well as using max occurs unbounded on some nodes.  Using Max Occurs unbounded in a positional flat file just will not work correctly as it cannot distinguish where one record finishes and the next begins.

    Does the length of the positional record change?  If not, then just set the Max Occurs to a fixed value and it might work.

    I set both the nodes to Min Occurs 2 and Max Occurs 2 and here is the result which matches what you want fairly closely.

    <Root xmlns="http://Test">
    	<Root_Child1 xmlns="">
    		<Root_Child1_Child1>3292015</Root_Child1_Child1>
    		<Root_Child1_Child2>
    			<Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    			<Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    			<Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    			<Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    			<Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    			<Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    			<Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    			<Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    			<Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    			<Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    			<Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    			<Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    			<Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    			<Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    		</Root_Child1_Child2>
    		<Root_Child1_Child2>
    			<Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    			<Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    			<Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    			<Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    			<Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    			<Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    			<Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    			<Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    			<Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    			<Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    			<Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    			<Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    			<Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    			<Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    		</Root_Child1_Child2>
    	</Root_Child1>
    	<Root_Child1 xmlns="">
    		<Root_Child1_Child1>4292015</Root_Child1_Child1>
    		<Root_Child1_Child2>
    			<Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    			<Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    			<Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    			<Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    			<Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    			<Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    			<Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    			<Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    			<Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    			<Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    			<Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    			<Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    			<Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    			<Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    		</Root_Child1_Child2>
    		<Root_Child1_Child2>
    			<Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    			<Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    			<Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    			<Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    			<Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    			<Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    			<Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    			<Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    			<Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    			<Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    			<Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    			<Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    			<Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    			<Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    			<Root_Child1_Child2_Child15>
    				<Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>
    			</Root_Child1_Child2_Child15>
    		</Root_Child1_Child2>
    	</Root_Child1>
    </Root>






    Thursday, November 21, 2019 10:33 PM
  • Hi Colin,

    Thanks for your suggestion.

    The length of the positional record will change 

    for example this whole set starting with 'E' will repeat multiple times and under this 'E' records we will have unbounded records

    <Root_Child1_Child2_Child1>E</Root_Child1_Child2_Child1>
    			<Root_Child1_Child2_Child2>01</Root_Child1_Child2_Child2>
    			<Root_Child1_Child2_Child3>1985-01-16</Root_Child1_Child2_Child3>
    			<Root_Child1_Child2_Child4>L99180</Root_Child1_Child2_Child4>
    			<Root_Child1_Child2_Child5>0</Root_Child1_Child2_Child5>
    			<Root_Child1_Child2_Child6>7</Root_Child1_Child2_Child6>
    			<Root_Child1_Child2_Child7>N</Root_Child1_Child2_Child7>
    			<Root_Child1_Child2_Child8>P</Root_Child1_Child2_Child8>
    			<Root_Child1_Child2_Child9>M</Root_Child1_Child2_Child9>
    			<Root_Child1_Child2_Child10>492</Root_Child1_Child2_Child10>
    			<Root_Child1_Child2_Child11>734</Root_Child1_Child2_Child11>
    			<Root_Child1_Child2_Child12>99</Root_Child1_Child2_Child12>
    			<Root_Child1_Child2_Child13>99</Root_Child1_Child2_Child13>
    			<Root_Child1_Child2_Child14>01</Root_Child1_Child2_Child14>
    			<Root_Child1_Child2_Child15>

    Unbounded under Record 'E'

    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>

    The unbounded record works for the outer unbounded 'E' Records but for nested unbounded it does not work but if I give only one Record under 'E' Record it works

    <Root_Child1_Child2_Child15_Child1>001</Root_Child1_Child2_Child15_Child1>
    				<Root_Child1_Child2_Child15_Child2>2008-10-01</Root_Child1_Child2_Child15_Child2>
    				<Root_Child1_Child2_Child15_Child3>00125000000</Root_Child1_Child2_Child15_Child3>

    I will try to set the max occurs as you have mentioned and get back to you,.

    Thanks


    Sri


    • Edited by Sriram27 Friday, November 22, 2019 3:00 AM update
    Friday, November 22, 2019 2:56 AM
  • In that case, you have to define a Tag Identifier on the Root_Child1_Child2 node, remove Root_Child2_Child1 and set the offset to 1 on the Root_Child1_Child2_Child2 rather than changing the Max and Min Occurs.

    <?xml version="1.0" encoding="utf-16"?>
    <xs:schema xmlns="http://Test" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" targetNamespace="http://Test" xmlns:xs="http://www.w3.org/2001/XMLSchema">
      <xs:annotation>
        <xs:appinfo>
          <schemaEditorExtension:schemaInfo namespaceAlias="b" extensionClass="Microsoft.BizTalk.FlatFileExtension.FlatFileExtension" standardName="Flat File" xmlns:schemaEditorExtension="http://schemas.microsoft.com/BizTalk/2003/SchemaEditorExtensions" />
          <b:schemaInfo standard="Flat File" codepage="65001" pad_char_type="char" count_positions_by_byte="false" parser_optimization="speed" lookahead_depth="3" suppress_empty_nodes="false" generate_empty_nodes="true" allow_early_termination="false" early_terminate_optional_fields="false" allow_message_breakup_of_infix_root="false" compile_parse_tables="false" root_reference="Root" default_pad_char=" " />
        </xs:appinfo>
      </xs:annotation>
      <xs:element name="Root">
        <xs:annotation>
          <xs:appinfo>
            <b:recordInfo structure="delimited" child_delimiter_type="hex" child_delimiter="0xD 0xA" child_order="infix" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
          </xs:appinfo>
        </xs:annotation>
        <xs:complexType>
          <xs:sequence>
            <xs:annotation>
              <xs:appinfo>
                <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
              </xs:appinfo>
            </xs:annotation>
            <xs:element minOccurs="0" maxOccurs="unbounded" name="Root_Child1">
              <xs:annotation>
                <xs:appinfo>
                  <b:recordInfo structure="positional" sequence_number="1" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
                </xs:appinfo>
              </xs:annotation>
              <xs:complexType>
                <xs:sequence>
                  <xs:annotation>
                    <xs:appinfo>
                      <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
                    </xs:appinfo>
                  </xs:annotation>
                  <xs:element name="Root_Child1_Child1" type="xs:string">
                    <xs:annotation>
                      <xs:appinfo>
                        <b:fieldInfo justification="left" pos_offset="0" pos_length="7" sequence_number="1" />
                      </xs:appinfo>
                    </xs:annotation>
                  </xs:element>
                  <xs:element minOccurs="1" maxOccurs="unbounded" name="Root_Child1_Child2">
                    <xs:annotation>
                      <xs:appinfo>
                        <b:recordInfo structure="positional" sequence_number="2" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" tag_name="E" tag_offset="0" />
                      </xs:appinfo>
                    </xs:annotation>
                    <xs:complexType>
                      <xs:sequence>
                        <xs:annotation>
                          <xs:appinfo>
                            <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
                          </xs:appinfo>
                        </xs:annotation>
                        <xs:element name="Root_Child1_Child2_Child2" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="1" pos_length="2" sequence_number="1" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child3" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="10" sequence_number="2" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child4" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="6" sequence_number="3" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child5" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="4" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child6" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="5" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child7" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="6" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child8" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="7" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child9" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="1" sequence_number="8" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child10" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="9" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child11" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="10" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child12" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="11" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child13" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="12" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element name="Root_Child1_Child2_Child14" type="xs:string">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:fieldInfo justification="left" pos_offset="0" pos_length="2" sequence_number="13" />
                            </xs:appinfo>
                          </xs:annotation>
                        </xs:element>
                        <xs:element minOccurs="0" maxOccurs="unbounded" name="Root_Child1_Child2_Child15">
                          <xs:annotation>
                            <xs:appinfo>
                              <b:recordInfo structure="positional" sequence_number="14" preserve_delimiter_for_empty_data="true" suppress_trailing_delimiters="false" />
                            </xs:appinfo>
                          </xs:annotation>
                          <xs:complexType>
                            <xs:sequence>
                              <xs:annotation>
                                <xs:appinfo>
                                  <groupInfo sequence_number="0" xmlns="http://schemas.microsoft.com/BizTalk/2003" />
                                </xs:appinfo>
                              </xs:annotation>
                              <xs:element name="Root_Child1_Child2_Child15_Child1" type="xs:string">
                                <xs:annotation>
                                  <xs:appinfo>
                                    <b:fieldInfo justification="left" pos_offset="0" pos_length="3" sequence_number="1" />
                                  </xs:appinfo>
                                </xs:annotation>
                              </xs:element>
                              <xs:element name="Root_Child1_Child2_Child15_Child2" type="xs:string">
                                <xs:annotation>
                                  <xs:appinfo>
                                    <b:fieldInfo justification="left" pos_offset="0" pos_length="10" sequence_number="2" />
                                  </xs:appinfo>
                                </xs:annotation>
                              </xs:element>
                              <xs:element name="Root_Child1_Child2_Child15_Child3" type="xs:string">
                                <xs:annotation>
                                  <xs:appinfo>
                                    <b:fieldInfo justification="left" pos_offset="0" pos_length="11" sequence_number="3" />
                                  </xs:appinfo>
                                </xs:annotation>
                              </xs:element>
                            </xs:sequence>
                          </xs:complexType>
                        </xs:element>
                      </xs:sequence>
                    </xs:complexType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:schema>



    • Edited by Colin Dijkgraaf Friday, November 22, 2019 3:14 AM
    • Marked as answer by Sriram27 Tuesday, November 26, 2019 3:24 AM
    Friday, November 22, 2019 3:10 AM
  • Hi Colin,

    It worked thank you so much


    Sri

    Tuesday, November 26, 2019 3:26 AM