| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Mapping Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| harry123 |
 Posted: Tue Mar 05, 2013 5:16 pm Post subject: Mapping Node |
 |
|
Newbie
Joined: 30 Oct 2012
Posts: 9
|
Hi,
I have a flow which maps an XML message to CSV using WMB v8.
My Model is as below.
SampleModel
sequence
Red
Sequence
field1
field2
Blue
sequence
field1
field2
Green
sequence
field1
field2
My I/P XML is as below.
<Red><field1>R1</field1><field2>R2</field2></Red>
<Blue><field1>B1</field1><field2>B2</field2></Blue>
<Green><field1>G1</field1><field2>G2</field2></Green>
<Red><field1>R3</field1><field2>R4</field2></Red>
<Blue><field1>B3</field1><field2>B4</field2></Blue>
<Green><field1>G3</field1><field2>G4</field2></Green>
the O/P CSV I'm getting after mapping is as below.
R1,R2
R3,R4
B1,B2
B3,B4
G1,G2
G3,G4
but I'm supposed to get my O/P CSV as
R1,R2
B1,B2
G1,G2
R3,R4
B3,B4
G3,G4
Can someone please help me out.
Thanks,
Harry |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Tue Mar 05, 2013 11:00 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
What methods have you tried? and what were the results?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Tue Mar 05, 2013 11:48 pm Post subject: Re: Mapping Node |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
This
| Code: |
<Red><field1>R1</field1><field2>R2</field2></Red>
<Blue><field1>B1</field1><field2>B2</field2></Blue>
<Green><field1>G1</field1><field2>G2</field2></Green>
<Red><field1>R3</field1><field2>R4</field2></Red>
<Blue><field1>B3</field1><field2>B4</field2></Blue>
<Green><field1>G3</field1><field2>G4</field2></Green> |
is that (your desired output):
| Code: |
R1,R2
B1,B2
G1,G2
R3,R4
B3,B4
G3,G4 |
How did you manage to mangle it (with the mapping node)?:
| Code: |
R1,R2
R3,R4
B1,B2
B3,B4
G1,G2
G3,G4
|
There is no mapping that you have to do.
Just parse it in with XMLNSC and put it out with a flat-file-message-set (probably "TDS").
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Mar 06, 2013 1:18 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
You're on v8, so I will assume that you are using DFDL to output the CSV.
I think I can guess at what's happening, but your description of the model is not detailed enough. Please can you post ( using code tags to make it readable, please ) the actual xsd. |
|
| Back to top |
|
|
| harry123 |
| Posted: Wed Mar 06, 2013 7:17 am Post subject: |
|
|
Newbie
Joined: 30 Oct 2012
Posts: 9
|
|
| 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
|
|
|
|
