Hi everybody,

   I need transform the xml file generated from dataset to a xml file with 2 
columns as attributes. Is there anyone using XSL stylesheet to transform the 
original xml to desired xml result? Thanks in advanced.

Original Xml File Structure:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <Products>
    <ProductID>01</ProductID>
    <ProductName>Raffles Chips</ProductName>
    <UnitPrice>8.2500</UnitPrice>
    <Quantity>1000</Quantity>
    <ReorderLevel>50</ReorderLevel>
  </Products>
  <Products>
    <ProductID>02</ProductID>
    <ProductName>GG Corn Chips</ProductName>
    <UnitPrice>7.5000</UnitPrice>
    <Quantity>1000</Quantity>
    <ReorderLevel>50</ReorderLevel>
  </Products>
  <Products>
    <ProductID>03</ProductID>
    <ProductName>J&J V-Cut Chips</ProductName>
    <UnitPrice>7.5000</UnitPrice>
    <Quantity>2000</Quantity>
    <ReorderLevel>100</ReorderLevel>
  </Products>
  <Products>
    <ProductID>04</ProductID>
    <ProductName>te</ProductName>
    <UnitPrice>5.2500</UnitPrice>
    <Quantity>56</Quantity>
    <ReorderLevel>4</ReorderLevel>
  </Products>
  <Products>
    <ProductID>05</ProductID>
    <ProductName>Jack</ProductName>
    <UnitPrice>4.5000</UnitPrice>
    <Quantity>200</Quantity>
    <ReorderLevel>1</ReorderLevel>
  </Products>
  <Products>
    <ProductID>06</ProductID>
    <ProductName>GHH</ProductName>
    <UnitPrice>8.0000</UnitPrice>
    <Quantity>920</Quantity>
    <ReorderLevel>7</ReorderLevel>
  </Products>
</NewDataSet>

Desired Xml Transformation(Result):
<?xml version="1.0" encoding="utf-8"?>
<Products>
	<Product Name="Raffles Chips" ID="01">		
		<UnitPrice>8.2500</UnitPrice>
		<Quantity>1000</Quantity>
		<ReorderLevel>50</ReorderLevel>
	</Product>
	<Product Name="GG Corn Chips" ID="02">		
		<UnitPrice>7.5000</UnitPrice>
		<Quantity>1000</Quantity>
		<ReorderLevel>50</ReorderLevel>
	</Product>
	<Product Name="J&J V-Cut Chips" ID="03">		
		<UnitPrice>7.5000</UnitPrice>
		<Quantity>2000</Quantity>
		<ReorderLevel>100</ReorderLevel>
	</Product>
	<Product Name="te" ID="04">		
		<UnitPrice>5.2500</UnitPrice>
		<Quantity>56</Quantity>
		<ReorderLevel>4</ReorderLevel>
	</Product>
	<Product Name="Jack" ID="05">		
		<UnitPrice>4.5000</UnitPrice>
		<Quantity>200</Quantity>
		<ReorderLevel>1</ReorderLevel>
	</Product>
	<Product Name="GHH" ID="06">		
		<UnitPrice>8.0000</UnitPrice>
		<Quantity>920</Quantity>
		<ReorderLevel>7</ReorderLevel>
	</Product>
</Products>


den2005

-- 
MCP Year 2005, Philippines