Remove From My Forums

Flat file schema wizard generation output is diferent

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

0

Sign in to vote

Can you explain how the generated output differs from the expected?

Wednesday, November 20, 2019 8:14 PM

Reply

|

Quote
0

Sign in to vote

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

Reply

|

Quote

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>

Proposed as answer by Colin Dijkgraaf Thursday, November 21, 2019 11:58 PM
Edited by Colin Dijkgraaf Thursday, November 21, 2019 11:58 PM

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

<?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

0

Sign in to vote

Hi Colin,

It worked thank you so much
Sri

Tuesday, November 26, 2019 3:26 AM

Reply

|

Quote

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

Answered by:

Flat file schema wizard generation output is diferent

Question

Answers

All replies