XML OUTPUT
Posted: Tue Dec 07, 2010 5:58 am
Hi Friends,
My source is a flat file and output is xml output stage.
targeted output is :
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
My output:
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
</fileList>
</fileUpdate>
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
Can any one help me how to acheive this.
Just to make it easy my targetted output is writing one header and one footer for whole lot of records.
But when I run my ds job my output is writing one header and one footer for each and every record.
Thanks
My source is a flat file and output is xml output stage.
targeted output is :
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
My output:
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1086734.10251.0.Z" sum="3574437120">
<store ncpdp="1086734"></store>
</file>
</fileList>
</fileUpdate>
<fileUpdate version="1" program="2" vendor="1" createDate="2010-12-07 06:52:14" serviceType="2">
0000000000000000001.
<fileList>
<file preReqFile="" id="1614608.10250.0.Z" sum="879672064">
<store ncpdp="1614608"></store>
</file>
</fileList>
</fileUpdate>
Can any one help me how to acheive this.
Just to make it easy my targetted output is writing one header and one footer for whole lot of records.
But when I run my ds job my output is writing one header and one footer for each and every record.
Thanks