Add nested xml as semi colon seperated values in collumn

May 17, 2012 at 4:45 PM

Hi, how difficult would it be to set up using an xml document with nested nodes e.g.

 

<root>
	<sampledata1>
		<data>test</data>
		<data1>test1</data1>
                <data2>
                         <subdata>subdata</subdata>
                         <subdata>subdata1</subdata>
                </data2>	
	</sampledata1>
	<sampledata2>
		<data>test2</data>
		<data1>test3</data1>
                <data2>
                         <subdata>subdata2</subdata>
                         <subdata>subdata3</subdata>
                </data2>
	</sampledata2>
</root>

and have the csv outputted like

test, test1, subdata; subdata1;
test2, test3, subdata2; subdata3;

At the moment it would view them as separate tables. Many thanks.