XmlSplit Example 5

Example 5: Split upon change of value of attribute "ID" in elements at depth 1.

Sample XML file orders_by_state_attribute.xml containing 5 STATE elements each with 10 ORDER elements

<ORDERS>
<STATE ID="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>
</STATE>
<STATE ID="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>
</STATE>
<STATE ID="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>
</STATE>
<STATE ID="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>
</STATE>
<STATE ID="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>
</STATE>
</ORDERS>

Split Method D is used in this example and the value "ID" is entered in the attribute name input box. This method works only for elements with a depth of one, so that field is readonly. The optional containing input is not used in this example, but if a value is entered the split occurs only if the specified attribute value matches the containing input.

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

Five split files are created. Each contains one STATE element at depth 1 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 STATE element 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.


<STATE ID="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>
</STATE>

Split file 2.

<STATE ID="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>
</STATE>