AnsweredAssumed Answered

How to transform data coming from database to xml output  based on a condition using groovy?

Question asked by mounika.jayanthi042656 on Mar 22, 2017
Latest reply on Mar 23, 2017 by Adam Arrowsmith

Hello Team,


I have a data coming from database out of which one field value is a:1|b:2| :3.......This Data with pipe symbols and : delimiter is dynamic.Now,this data has to be split into below XML structure:

















This kind of splitting is for one field from database.Like this I have 2 more fields which has to split like above


Once i achieve this XML format,I need to combine these xml's and map with final data based on primary key of database.

Can you please help me Adam Arrowsmith   with groovy scripting?


I have referred to  link and need some inputs on my requirement