| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| CSV to XML to CSV formatted data |
« View previous topic :: View next topic » |
| Author |
Message
|
| Mohit Gupta |
 Posted: Mon Nov 15, 2004 11:11 pm Post subject: CSV to XML to CSV formatted data |
 |
|
Apprentice
Joined: 16 Sep 2004
Posts: 34
|
Hi ,
I have created two physical properties XML1 and TDS1 . I receive input in csv format and down the processing in xml domain by applying RCD (XML1) and now i want it back to csv format but when i apply the rcd again with message format TDS1 i am not getting the comma separated but simply one line message containing xml data as string.
for .eg.
if my input message is like this...
1,1000,FK,03/04/2004,333213.323,3213123.323
2,1000,FK,03/04/2004,-333213.323,-3213123.33
and i convert it into XMl like this
<File>
<RowSet id="UnProcessed">
<Row>
<Company>1000</Company>
<DueDate>04/04/2004</DueDate>
...
</Row>
</RowSet>
</File>
Now i want the data back in this format
1,1000,FK,04/04/2004,435213.323,543123.323
How do i acheive that?
Cheers
Mohit |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Nov 15, 2004 11:36 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I don't see any difference between your original (TDS) message format and final TDS message format. May I ask why do you want to do this muti-stage parsing?
Once you parse your input message you can use Flow Order node to branch your message flow to two different paths. In first path you can convert TDS to XML format and in second path you don't need to parse it again as your message is already in TDS format.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Mohit Gupta |
| Posted: Tue Nov 16, 2004 12:22 am Post subject: |
|
|
Apprentice
Joined: 16 Sep 2004
Posts: 34
|
Yeah you are correct but my requirement is somewhat different.
If you notice in my incoming message i have amounts field . I want to do GROUP BY on the message data for that i have written xsl which does the grouping operation and other tasks also. For that i needed an xml formatted input.
Cheers,
Mohit |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Nov 16, 2004 6:13 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Does anyone have anything resembling solid facts comparing the peformance of XSL transformations vs. ESQL transformations in WBIMB?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| shanson |
| Posted: Tue Nov 16, 2004 9:19 am Post subject: |
|
|
Partisan
Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley
|
| Mohit, I think your problem may be that the output from the XMLT node is in the BLOB domain (because an XSL transform can produce non-XML output). So you need to RCD the output as MRM XML1 again to create the correct tree. Then you simply reset the Properties folder Format property to TDS1 and the CSV format should appear on output. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
