Answered by:
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
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
All replies
-
-
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
-
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
-
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
-
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
-