XmlSplit Example 4

Example 4: Split upon change of tag name of Element at depth 1.

Sample XML file orders_by_state.xml containing 50 ORDER elements

<ORDERS>
<ALABAMA>
<ORDER>
<O_ORDERKEY>1</O_ORDERKEY>
<O_CUSTKEY>370</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>172799.49</O_TOTALPRICE>
<O_ORDERDATE>1996-01-02</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000951</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>blithely final dolphins solve-- blithely blithe packages nag blith</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>2</O_ORDERKEY>
<O_CUSTKEY>781</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>38426.09</O_TOTALPRICE>
<O_ORDERDATE>1996-12-01</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000880</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>quickly regular depend</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>3</O_ORDERKEY>
<O_CUSTKEY>1234</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>205654.30</O_TOTALPRICE>
<O_ORDERDATE>1993-10-14</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000955</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>deposits alongside of the dependencies are slowly about </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>4</O_ORDERKEY>
<O_CUSTKEY>1369</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>56000.91</O_TOTALPRICE>
<O_ORDERDATE>1995-10-11</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000124</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>final requests detect slyly across the blithely bold pinto beans. eve</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>5</O_ORDERKEY>
<O_CUSTKEY>445</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>105367.67</O_TOTALPRICE>
<O_ORDERDATE>1994-07-30</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000925</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>even deposits cajole furiously. quickly spe</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>6</O_ORDERKEY>
<O_CUSTKEY>557</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>45523.10</O_TOTALPRICE>
<O_ORDERDATE>1992-02-21</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000058</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironically bold asymptotes sleep blithely beyond the regular, clos</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>7</O_ORDERKEY>
<O_CUSTKEY>392</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>271885.66</O_TOTALPRICE>
<O_ORDERDATE>1996-01-10</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000470</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironic, regular deposits are. ironic foxes sl</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>32</O_ORDERKEY>
<O_CUSTKEY>1301</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>198665.57</O_TOTALPRICE>
<O_ORDERDATE>1995-07-16</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000616</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly final foxes are slyly. packag</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>33</O_ORDERKEY>
<O_CUSTKEY>670</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>146567.24</O_TOTALPRICE>
<O_ORDERDATE>1993-10-27</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000409</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>packages maintain about the deposits; foxes hang after </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>34</O_ORDERKEY>
<O_CUSTKEY>611</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>73315.48</O_TOTALPRICE>
<O_ORDERDATE>1998-07-21</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000223</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>quickly express asymptotes use. carefully final packages sleep f</O_COMMENT>
</ORDER>
</ALABAMA>
<ALASKA>
<ORDER>
<O_ORDERKEY>35</O_ORDERKEY>
<O_CUSTKEY>1276</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>194641.93</O_TOTALPRICE>
<O_ORDERDATE>1995-10-23</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000259</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>fluffily regular pinto beans </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>36</O_ORDERKEY>
<O_CUSTKEY>1153</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>42011.04</O_TOTALPRICE>
<O_ORDERDATE>1995-11-03</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000358</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully ironic accounts nag</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>37</O_ORDERKEY>
<O_CUSTKEY>862</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>131896.49</O_TOTALPRICE>
<O_ORDERDATE>1992-06-03</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000456</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>express requests ar</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>38</O_ORDERKEY>
<O_CUSTKEY>1249</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>71553.08</O_TOTALPRICE>
<O_ORDERDATE>1996-08-21</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000604</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly quick pinto beans detect flu</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>39</O_ORDERKEY>
<O_CUSTKEY>818</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>326565.37</O_TOTALPRICE>
<O_ORDERDATE>1996-09-20</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000659</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>furiously unusual pinto beans above the furiously ironic asymptot</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>64</O_ORDERKEY>
<O_CUSTKEY>322</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>35831.73</O_TOTALPRICE>
<O_ORDERDATE>1994-07-16</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000661</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>final deposits nag. blithely special deposits a</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>65</O_ORDERKEY>
<O_CUSTKEY>163</O_CUSTKEY>
<O_ORDERSTATUS>P</O_ORDERSTATUS>
<O_TOTALPRICE>95469.44</O_TOTALPRICE>
<O_ORDERDATE>1995-03-18</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000632</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>furiously even platelets boost ironic theodolites. even </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>66</O_ORDERKEY>
<O_CUSTKEY>1292</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>104190.66</O_TOTALPRICE>
<O_ORDERDATE>1994-01-20</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000743</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironic requests are quickly about the carefully unusual a</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>67</O_ORDERKEY>
<O_CUSTKEY>568</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>182481.16</O_TOTALPRICE>
<O_ORDERDATE>1996-12-19</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000547</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>regular, bold foxes across the even requests detect a</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>68</O_ORDERKEY>
<O_CUSTKEY>286</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>301968.79</O_TOTALPRICE>
<O_ORDERDATE>1998-04-18</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000440</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>stealthy decoys nag; furiously</O_COMMENT>
</ORDER>
</ALASKA>
<ARIZONA>
<ORDER>
<O_ORDERKEY>69</O_ORDERKEY>
<O_CUSTKEY>845</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>204110.73</O_TOTALPRICE>
<O_ORDERDATE>1994-06-04</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000330</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully regular theodolites exce</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>70</O_ORDERKEY>
<O_CUSTKEY>644</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>125705.32</O_TOTALPRICE>
<O_ORDERDATE>1993-12-18</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000322</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>blithely unusual pack</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>71</O_ORDERKEY>
<O_CUSTKEY>34</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>260603.38</O_TOTALPRICE>
<O_ORDERDATE>1998-01-24</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000271</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>furiously ironic dolphins sleep slyly. carefully special notornis cajole c</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>96</O_ORDERKEY>
<O_CUSTKEY>1078</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>64364.30</O_TOTALPRICE>
<O_ORDERDATE>1994-04-17</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000395</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully regular accounts </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>97</O_ORDERKEY>
<O_CUSTKEY>211</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>100572.55</O_TOTALPRICE>
<O_ORDERDATE>1993-01-29</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000547</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully even packages believe sly</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>98</O_ORDERKEY>
<O_CUSTKEY>1045</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>71721.40</O_TOTALPRICE>
<O_ORDERDATE>1994-09-25</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000448</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully even dinos sleep blithely. regular, bold deposits</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>99</O_ORDERKEY>
<O_CUSTKEY>890</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>108594.87</O_TOTALPRICE>
<O_ORDERDATE>1994-03-13</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000973</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully regular theodolites may believe unu</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>100</O_ORDERKEY>
<O_CUSTKEY>1471</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>198978.27</O_TOTALPRICE>
<O_ORDERDATE>1998-02-28</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000577</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>regular deposits sleep closely regular, regular packages. carefully si</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>101</O_ORDERKEY>
<O_CUSTKEY>280</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>118448.39</O_TOTALPRICE>
<O_ORDERDATE>1996-03-17</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000419</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>blithely ironic accounts lose slyly about the pending, regular accounts</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>102</O_ORDERKEY>
<O_CUSTKEY>8</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>184806.58</O_TOTALPRICE>
<O_ORDERDATE>1997-05-09</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000596</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>unusual deposits dazzle furiously blithely regular pinto beans. pending foxes</O_COMMENT>
</ORDER>
</ARIZONA>
<ARKANSAS>
<ORDER>
<O_ORDERKEY>103</O_ORDERKEY>
<O_CUSTKEY>292</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>118745.16</O_TOTALPRICE>
<O_ORDERDATE>1996-06-20</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000090</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully ironic deposits are quickly blithely even</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>128</O_ORDERKEY>
<O_CUSTKEY>740</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>34997.04</O_TOTALPRICE>
<O_ORDERDATE>1992-06-15</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000385</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully special e</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>129</O_ORDERKEY>
<O_CUSTKEY>712</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>254281.41</O_TOTALPRICE>
<O_ORDERDATE>1992-11-19</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000859</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly bold dolphins cajole c</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>130</O_ORDERKEY>
<O_CUSTKEY>370</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>140213.54</O_TOTALPRICE>
<O_ORDERDATE>1992-05-08</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000036</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly final accounts among</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>131</O_ORDERKEY>
<O_CUSTKEY>928</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>140726.47</O_TOTALPRICE>
<O_ORDERDATE>1994-06-08</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000625</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>special courts wake blithely accordin</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>132</O_ORDERKEY>
<O_CUSTKEY>265</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>133485.89</O_TOTALPRICE>
<O_ORDERDATE>1993-06-11</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000488</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironic platelets according to the evenly regula</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>133</O_ORDERKEY>
<O_CUSTKEY>440</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>95971.06</O_TOTALPRICE>
<O_ORDERDATE>1997-11-29</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000738</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly silent deposits haggle carefully fluffi</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>134</O_ORDERKEY>
<O_CUSTKEY>62</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>208201.46</O_TOTALPRICE>
<O_ORDERDATE>1992-05-01</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000711</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>silently even deposits wake about the fluff</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>135</O_ORDERKEY>
<O_CUSTKEY>605</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>230472.84</O_TOTALPRICE>
<O_ORDERDATE>1995-10-21</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000804</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>accounts cajole. final, pending dependencies a</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>160</O_ORDERKEY>
<O_CUSTKEY>826</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>114742.32</O_TOTALPRICE>
<O_ORDERDATE>1996-12-19</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000342</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>unusual dependencie</O_COMMENT>
</ORDER>
</ARKANSAS>
<CALIFORNIA>
<ORDER>
<O_ORDERKEY>161</O_ORDERKEY>
<O_CUSTKEY>167</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>17668.60</O_TOTALPRICE>
<O_ORDERDATE>1994-08-31</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000322</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironic, even attainments cajole closely</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>162</O_ORDERKEY>
<O_CUSTKEY>142</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>3553.15</O_TOTALPRICE>
<O_ORDERDATE>1995-05-08</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000378</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>instructions nag slyly. fluffily ironic sau</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>163</O_ORDERKEY>
<O_CUSTKEY>878</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>177809.13</O_TOTALPRICE>
<O_ORDERDATE>1997-09-05</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000379</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully express pinto beans serve carefully final as</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>164</O_ORDERKEY>
<O_CUSTKEY>8</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>250417.20</O_TOTALPRICE>
<O_ORDERDATE>1992-10-21</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000209</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>fluffily unusual requests al</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>165</O_ORDERKEY>
<O_CUSTKEY>274</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>193302.35</O_TOTALPRICE>
<O_ORDERDATE>1993-01-30</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000292</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>furiously enticing accounts cajole sometimes. slyly express plat</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>166</O_ORDERKEY>
<O_CUSTKEY>1079</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>158207.39</O_TOTALPRICE>
<O_ORDERDATE>1995-09-12</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000440</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>bold dependencies wake furiously regula</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>167</O_ORDERKEY>
<O_CUSTKEY>1195</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>64017.85</O_TOTALPRICE>
<O_ORDERDATE>1993-01-04</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000731</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>express warhorses wake carefully furiously ironic deposits. c</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>192</O_ORDERKEY>
<O_CUSTKEY>826</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>194637.57</O_TOTALPRICE>
<O_ORDERDATE>1997-11-25</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000483</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>silent requests above the furiously even pinto beans sleep bl</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>193</O_ORDERKEY>
<O_CUSTKEY>791</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>80834.26</O_TOTALPRICE>
<O_ORDERDATE>1993-08-08</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000025</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly blithe instructions cajole carefully ironic, fina</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>194</O_ORDERKEY>
<O_CUSTKEY>619</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>154284.73</O_TOTALPRICE>
<O_ORDERDATE>1992-04-05</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000352</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully dogged excuses use abou</O_COMMENT>
</ORDER>
</CALIFORNIA>
</ORDERS>

Method C on the Methods tab is used in this example

No items on the Options Tab are specified for this example including the root element which must be blank.

All elements at depth 1 in the source XML document are USA state names. There are five such elements. Five split files are created. Each contains one state element from the source XML file with all of the ORDER elements for that state. Note that no root element is specified in the Wizard because the element with the state name becomes the root in each split file. A root element could be specified should one wish to encapsulate the state element within a different root.

First two split files created are below:

Split file 1.


<ALABAMA>
<ORDER>
<O_ORDERKEY>1</O_ORDERKEY>
<O_CUSTKEY>370</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>172799.49</O_TOTALPRICE>
<O_ORDERDATE>1996-01-02</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000951</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>blithely final dolphins solve-- blithely blithe packages nag blith</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>2</O_ORDERKEY>
<O_CUSTKEY>781</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>38426.09</O_TOTALPRICE>
<O_ORDERDATE>1996-12-01</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000880</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>quickly regular depend</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>3</O_ORDERKEY>
<O_CUSTKEY>1234</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>205654.30</O_TOTALPRICE>
<O_ORDERDATE>1993-10-14</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000955</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>deposits alongside of the dependencies are slowly about </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>4</O_ORDERKEY>
<O_CUSTKEY>1369</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>56000.91</O_TOTALPRICE>
<O_ORDERDATE>1995-10-11</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000124</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>final requests detect slyly across the blithely bold pinto beans. eve</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>5</O_ORDERKEY>
<O_CUSTKEY>445</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>105367.67</O_TOTALPRICE>
<O_ORDERDATE>1994-07-30</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000925</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>even deposits cajole furiously. quickly spe</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>6</O_ORDERKEY>
<O_CUSTKEY>557</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>45523.10</O_TOTALPRICE>
<O_ORDERDATE>1992-02-21</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000058</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironically bold asymptotes sleep blithely beyond the regular, clos</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>7</O_ORDERKEY>
<O_CUSTKEY>392</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>271885.66</O_TOTALPRICE>
<O_ORDERDATE>1996-01-10</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000470</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironic, regular deposits are. ironic foxes sl</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>32</O_ORDERKEY>
<O_CUSTKEY>1301</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>198665.57</O_TOTALPRICE>
<O_ORDERDATE>1995-07-16</O_ORDERDATE>
<O_ORDER-PRIORITY>2-HIGH</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000616</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly final foxes are slyly. packag</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>33</O_ORDERKEY>
<O_CUSTKEY>670</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>146567.24</O_TOTALPRICE>
<O_ORDERDATE>1993-10-27</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000409</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>packages maintain about the deposits; foxes hang after </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>34</O_ORDERKEY>
<O_CUSTKEY>611</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>73315.48</O_TOTALPRICE>
<O_ORDERDATE>1998-07-21</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000223</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>quickly express asymptotes use. carefully final packages sleep f</O_COMMENT>
</ORDER>
</ALABAMA>

Split file 2.

<ALASKA>
<ORDER>
<O_ORDERKEY>35</O_ORDERKEY>
<O_CUSTKEY>1276</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>194641.93</O_TOTALPRICE>
<O_ORDERDATE>1995-10-23</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000259</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>fluffily regular pinto beans </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>36</O_ORDERKEY>
<O_CUSTKEY>1153</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>42011.04</O_TOTALPRICE>
<O_ORDERDATE>1995-11-03</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000358</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>carefully ironic accounts nag</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>37</O_ORDERKEY>
<O_CUSTKEY>862</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>131896.49</O_TOTALPRICE>
<O_ORDERDATE>1992-06-03</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000456</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>express requests ar</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>38</O_ORDERKEY>
<O_CUSTKEY>1249</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>71553.08</O_TOTALPRICE>
<O_ORDERDATE>1996-08-21</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000604</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>slyly quick pinto beans detect flu</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>39</O_ORDERKEY>
<O_CUSTKEY>818</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>326565.37</O_TOTALPRICE>
<O_ORDERDATE>1996-09-20</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000659</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>furiously unusual pinto beans above the furiously ironic asymptot</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>64</O_ORDERKEY>
<O_CUSTKEY>322</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>35831.73</O_TOTALPRICE>
<O_ORDERDATE>1994-07-16</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000661</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>final deposits nag. blithely special deposits a</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>65</O_ORDERKEY>
<O_CUSTKEY>163</O_CUSTKEY>
<O_ORDERSTATUS>P</O_ORDERSTATUS>
<O_TOTALPRICE>95469.44</O_TOTALPRICE>
<O_ORDERDATE>1995-03-18</O_ORDERDATE>
<O_ORDER-PRIORITY>1-URGENT</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000632</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>furiously even platelets boost ironic theodolites. even </O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>66</O_ORDERKEY>
<O_CUSTKEY>1292</O_CUSTKEY>
<O_ORDERSTATUS>F</O_ORDERSTATUS>
<O_TOTALPRICE>104190.66</O_TOTALPRICE>
<O_ORDERDATE>1994-01-20</O_ORDERDATE>
<O_ORDER-PRIORITY>5-LOW</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000743</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>ironic requests are quickly about the carefully unusual a</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>67</O_ORDERKEY>
<O_CUSTKEY>568</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>182481.16</O_TOTALPRICE>
<O_ORDERDATE>1996-12-19</O_ORDERDATE>
<O_ORDER-PRIORITY>4-NOT SPECIFIED</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000547</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>regular, bold foxes across the even requests detect a</O_COMMENT>
</ORDER>
<ORDER>
<O_ORDERKEY>68</O_ORDERKEY>
<O_CUSTKEY>286</O_CUSTKEY>
<O_ORDERSTATUS>O</O_ORDERSTATUS>
<O_TOTALPRICE>301968.79</O_TOTALPRICE>
<O_ORDERDATE>1998-04-18</O_ORDERDATE>
<O_ORDER-PRIORITY>3-MEDIUM</O_ORDER-PRIORITY>
<O_CLERK>Clerk#000000440</O_CLERK>
<O_SHIP-PRIORITY>0</O_SHIP-PRIORITY>
<O_COMMENT>stealthy decoys nag; furiously</O_COMMENT>
</ORDER>
</ALASKA>