AnsweredAssumed Answered

Idoc to csv file conversion in boomi with max occur as unbounded options

Question asked by arpit.shrivastava819380 on Jul 12, 2018
Latest reply on Jul 13, 2018 by arpit.shrivastava819380

I am having one IDoc,which is having metadata as xml. Now I want to transform it to a flat file which I am doing in my process's map shape. But the segment of the idoc is having max occur as unbounded so it can repeat any number of time. I want to create a csv file such that when repititive segments do occur it should club all the repititive values in seperate lines and then the next segment.

For eg: If this is my xml:

<Parent>
<child>
<sibling>25</sibling>
<sibling2>29</sibling2>
</child>
<child>
<sibling>25</sibling>
<sibling2>29</sibling2>
</child>
<child>
<sibling>25</sibling>
<sibling2>29</sibling2>
</child>
<cousin>
<friend>21</friend>
<friend1>22</friend1>
<friend2>23</friend2>
</cousin>
</Parent>

it should produce:

25,29
25,29
25,29
21,22,23

and not
25,29
21,22,23
25,29
21,22,23
25,29
21,22,23

Outcomes