Help with creating xml fles from one xml files

Hi,

How do you create multiple xml files based on a data element?  For example if I have the following xml file:

Final.xml

  <Root>
	  <Table_NSC>
		  <ID> 1</ID>
			<CTRY>BEL</CTRY>
		  <NSC></NSC>
	  </Table_NSC>
	  <Table_NSC>
		  <ID> 2</ID>
			<CTRY>CAN</CTRY>
		  <NSC></NSC>
	  </Table_NSC>
	  <Table_NSC>
		  <ID> 3</ID>
			<CTRY>CAN</CTRY>
		  <NSC></NSC>
	  </Table_NSC>
	  <Table_NSC>
		  <ID> 4</ID>
			<CTRY>DEU</CTRY>
		  <NSC></NSC>
	  </Table_NSC>
  </Root>

Select allOpen in new window

How do I create the following xml files?

  <Root>
	  <Table_NSC>
		  <ID> 1</ID>
			<CTRY>BEL</CTRY>
		  <NSC></NSC>
	  </Table_NSC>
</Root>  

Select allOpen in new window

CAN.xml

<Root>
	<Table_NSC>
		<ID> 2</ID>
			<CTRY>CAN</CTRY>
		<NSC></NSC>
	</Table_NSC>
	<Table_NSC>
		<ID> 3</ID>
			<CTRY>CAN</CTRY>
		<NSC></NSC>
	</Table_NSC>
</Root>

Select allOpen in new window

DEU.xml

<Root>
	<Table_NSC>
		<ID> 4</ID>
			<CTRY>DEU</CTRY>
		<NSC></NSC>
	</Table_NSC>
</Root>  

Select allOpen in new window

Thanks,

Victor