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:

 

<parent>

  <child>

         <code>a</code>

          <text>1</text>

</child>

<child>

         <code>b</code>

          <text>2</text>

</child>

<child>

         </code>

          <text>3</text>

</child>

</parent>

 

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 https://community.boomi.com/message/14755?commentID=14755#comment-14755  link and need some inputs on my requirement

 

Thanks,

Mounika

Outcomes