Generate multiple xml files using values in a attribute

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
babbu9
Premium Member
Premium Member
Posts: 75
Joined: Tue Jun 01, 2004 9:44 am

Generate multiple xml files using values in a attribute

Post by babbu9 »

Hi
I need to create dynamic xml files based on the values of data in a field.

Field
123
124
125
126
...


Filenames
123.xml
124.xml
125.xml
126.xml
....


Should produce data corresponding to that college in the file and have the filename with the attribute value.

How can I accomplish this? Please inform.
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

You didn't say which Stage you are using....

...if the xmlOutput Stage, then sort your data by that column...meaning all the rows for a given document, in sorted order by those column's values...

...then specify that column as a "trigger" column. It might not be "exactly" the naming convention you are looking for, but it will cut new files based on the sort breaks.

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply