AnsweredAssumed Answered

How can I expand one XML node values into multiple XML nodes?

Question asked by RanjiniElamkulammana2391 on Sep 14, 2016
Latest reply on Sep 15, 2016 by 51662476

<someroot>

.......<4thLevelNodeI>34,56,27</4thLevelNode>

</someroot>

 

what this needs to become is

<someroot>

.......

<4thLevelNodeO>34</4thLevelNodeO>

<4thLevelNodeO>56</4thLevelNodeO>

<4thLevelNodeO>27</4thLevelNodeO>

</someroot>

 

questions:

1. Can this be done from XML to XML map?

2. is Groovy an option or the only option?

3. can Doccache be used in someway? 4thLevelNodeI -> docCache (multiple rows) -> mapto ->4thLevelNodeO

 

Appreciate help

Outcomes