DSXchange

Posted: **Sat Dec 01, 2012 10:19 am**

Hi Experts
I need your help !!!
Currently working on DS 8.1 installed on a Unix box (server) / client running on Windows

In a parallele job I would like to load a XML file which uses the structure below:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2012-11-08T16:01:23">
	<T0041DIST>
		<Kantoor>499</Kantoor>
		<KantoorTaalregime>3</KantoorTaalregime>
		<Directie>2</Directie>
	</T0041DIST>
	<T0041DIST>
		<Kantoor>500</Kantoor>
		<KantoorTaalregime>2</KantoorTaalregime>
		<Directie>0</Directie>
	</T0041DIST>
	<T0041DIST>
		<Kantoor>501</Kantoor>
		<KantoorTaalregime>2</KantoorTaalregime>
		<Directie>3</Directie>
	</T0041DIST>
        .....
</dataroot>

I would like to extract all the data from the XML file and save it in a flat file/database...whatever as below

Code: Select all

Kantoor    KantoorTaalregime    Directie
499        3                    2
500        2                    0
501        2                    3
....

Currently I'm able to load the file if there is only a single node (<T0041DIST>) in the XML file as below (see the structure of the XML file below) using the following Stages:

Sequential File -> XML input -> Sequential file

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2012-11-08T16:01:23">
	<T0041DIST>
		<Kantoor>499</Kantoor>
		<KantoorTaalregime>3</KantoorTaalregime>
		<Directie>2</Directie>
	</T0041DIST>
</dataroot>

BUT NOW how to read the file when the main node is repeated ? and extract all the data ???

Thanks in advance for your help

Posted: **Sat Dec 01, 2012 7:10 pm**

First off do not use a Sequential File stage to read your XML, use the External Source Stage as noted here. I'd also be curious if you marked one element as the 'repetition key' by noting it as a key column? If not try making one of the lowest level elements as the key, say "Directie". Once setup correctly it should all just happen automagically.

DSXchange

XML source File -> EXTRACT DATA

XML source File -> EXTRACT DATA