XML output Stage
Posted: Tue May 19, 2009 7:44 am
Hi All,
I am facing the problem with the XML output stage.
My i/p:
rowid|result
1|abc
1|xdf
3|asd
I am using rowid as a trigger column.
So for rowid 1 the corresopnding result values abc,xdf should come under a single rowid chunk
means i want the output xml like this
<DMSMessage>
<sourceSystemEventId>1</sourceSystemEventId>
<retryCount>abc</retryCount>
<retryCount>xdf</retryCount>
</DMSMessage>
but for i am getting like this
<DMSMessage>
<sourceSystemEventId>1</sourceSystemEventId>
<retryCount>abc</retryCount>
</DMSMessage>
<DMSMessage>
<sourceSystemEventId>1</sourceSystemEventId>
<retryCount>xdf</retryCount>
</DMSMessage>
To achive this do we need to set any thing in the XML output stage
can any knows please help me
Thanks for your help
I am facing the problem with the XML output stage.
My i/p:
rowid|result
1|abc
1|xdf
3|asd
I am using rowid as a trigger column.
So for rowid 1 the corresopnding result values abc,xdf should come under a single rowid chunk
means i want the output xml like this
<DMSMessage>
<sourceSystemEventId>1</sourceSystemEventId>
<retryCount>abc</retryCount>
<retryCount>xdf</retryCount>
</DMSMessage>
but for i am getting like this
<DMSMessage>
<sourceSystemEventId>1</sourceSystemEventId>
<retryCount>abc</retryCount>
</DMSMessage>
<DMSMessage>
<sourceSystemEventId>1</sourceSystemEventId>
<retryCount>xdf</retryCount>
</DMSMessage>
To achive this do we need to set any thing in the XML output stage
can any knows please help me
Thanks for your help