|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
ESQL |
« View previous topic :: View next topic » |
Author |
Message
|
Accell |
Posted: Sat Aug 22, 2015 4:50 am Post subject: ESQL |
|
|
Novice
Joined: 07 Feb 2015 Posts: 24
|
Dear all,
I am working with a csv to xml conversion in which i need to create an xml file based on a unique element:
For eg:
Input csv is like:
a,b,c.x.y
a,b,c,x1,y
a,b,c,x1,y,
a,b,c,x1,y
a,b,c,x2,y
a,b,c,x2,y
where the output should be one file for all records with X1
as soon as the value of x changes suppose x2, that constitutes a second file.
I tried storing the value of x in the environment variable but it does not work as expected.
Could you please guide me on this. |
|
Back to top |
|
 |
fjb_saper |
Posted: Sat Aug 22, 2015 8:43 am Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
You need to model your input in DFDL. When you then parse it, it will be really easy to turn the parsed tree into XML.
Have fun  _________________ MQ & Broker admin |
|
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
|
|
|
|