XML Input, Reading the repeated elements

[swades]

Hi,

I am trying to read the repeated elements of an XML. The part of the XML looks like ...
.......
.......
<Customer>
<Phone number="Home">5715271662</Phone>
<Phone number="Mobile">5715271663</Phone>
</Customer>
<Location>
<City name="One">Reston</City>
<City name="Two">Herndon</City>
</Location>
.......
.......

I am using the seqfile stage---> xml input stage ---> transformer ---> oracle stage

In the XML input stage, I gave the following XPaths (in description) to read those values. And mentioned the Phonetype as the repetitive element(Key).

Phonetype --> ....../Customer/Phone/@number
Number --> ....../Customer/Phone/text()
Citytype --> ...../Location/City/@schemeName
Cityname --> ...../Location/City/text()

but, it gives the output as

Phonetype Number Citytype Cityname
---------- ------- ---------- -------
Home 5715271662 One Reston
Mobile 5715271663 One Reston

I need the output as

Phonetype Number Citytype Cityname
---------- ------- ---------- -------
Home 5715271662 One Reston
Mobile 5715271663 Two Herndon

We cannot declare more than one key field. But, there should be someway to read them to get the mentioned output.
I am not sure whether to mention something in the derivation of the xml input stage.
Would anyone please help me out?

Thanks,
Swades

[JoshGeorge]

Try reading the XML with just 2 fileds:

Code: Select all

Phonetype --> ....../Customer/Phone/@number 
Number --> ....../Customer/Phone/text() 

And specify 'Phonetype' as repetition element.