XML outputing Duplicate Tags

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nisusmage
Premium Member
Premium Member
Posts: 103
Joined: Mon May 07, 2007 1:57 am

XML outputing Duplicate Tags

Post by Nisusmage »

Hello All,

I'm using a XMLOutput stage to render records into a XML Chunk. Most of it is working well except for a few small records. I've output tab I set the output mode to "Aggregate all rows", could this be the problem? I doubt it though, because all the other records are fine.

The Records:
ContractID,ContractRef,Amount,Frequency
74137699,40100036892,25.000,M
74137701,40100036892,25.000,M

Descriptions are as follows:
/Table/Record/contractID/text()
/Table/Record/contractRef/text()
/Table/Record/Amount/text()
/Table/Record/Frequency/text()

Renders in XML as:
<contractid>74137699</contractid>
<contractid>74137699</contractid>
<contractref>40100036892</contractref>
<amount>25.00</amount>
<frequency>M</frequency>

Please can someone help here. I'm stumped.
~The simpliest solutions are always the best~
~Trick is to understand the complexity to implement simplicity~
Nisusmage
Premium Member
Premium Member
Posts: 103
Joined: Mon May 07, 2007 1:57 am

Post by Nisusmage »

Solution:

It's all about the "KEY"!

viewtopic.php?p=277568
~The simpliest solutions are always the best~
~Trick is to understand the complexity to implement simplicity~
Post Reply