Handling XML Repetitions

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Handling XML Repetitions

Post by mydsworld »

I have the following data as input to XML Output stage.

customer division city
acme toys boston
acme toys new york
acme chemical boston
acme chemical new york

1st column : /customer/@name
2nd column : /customer/division/text()
3rd column : /customer/city/text()

My intention is to get XML output like this :

<customer name = "acme">
<division> toys </division>
<city> boston </city>

<division> toys </division>
<city> new york </city>

<division> chemical </division>
<city> boston </city>

<division> chemical </division>
<city> new york </city>
</customer


Please let me know which element should I choose as 'Repeition Element' to achieve this.
Post Reply