AnsweredAssumed Answered

How to create a nested XML Output

Question asked by Mike Spiegel on May 4, 2019
Latest reply on May 6, 2019 by Johan Hammink


How can I create a nested XML output that takes multiple sets of data and combines them into a single nested XML output?   I've tried multiple different steps with the XML joins, streams, merges, etc, and none of them provide me with the results I need. 

 

I'm looking to create something that looks like this:

 

<samplefile>

<headerinfo>

<numrec>5</numrec>

<sumAmt>100.00</sumAmt>

</headerinfo>

<consumer>

<name>mike></name>

<add1>123 Main St</add1>

</consumer>

<detail>

<car>Y</car>

<mortg>N</mortg>

<income>

<salary>1000.00</salary>

</income>

</detail>

</samplefile>

 

Attached is a short sample copy of a KTR file with two data sets that I'm trying to work with to get closer to my desired result.   Is this just not possible with this product?

 

Thanks,

 

Mike

Attachments

Outcomes