How to map a non loop element to a loop element in tXMLMap

[Anonymous]

Hi,

I post link to the question also here because it has not been answered. 
[topic]30785[/topic]

Regards,

Teemu

[Anonymous]

Hi Teemu,

Could you please elaborate your case with an example with input and expected output values?

Best regards
Sabrina

[Anonymous]

Hi,

My case is somewhat similar to Padmaraj's in the linked post. In my case input is database records with separate address fields for home and business and output should be looping address types in xml format.

Input fields are something like:

Home address line 1
Home address line 2 
Business address line 1
Business address line 2

In the target xsd schema there is a looping Address element. Output should be like:

                <Address Type="Home">
                     <Line1>Line 1</Line1>
                     <Line2>Line 2</Line2>
                 </Address>
                <Address Type="Business">
                     <Line1>Line 1</Line1>
                     <Line2>Line 2</Line2>
                 </Address>

I don't know how to achieve this with tXMLMap. 

-Teemu

[Anonymous]

Any ideas how to solve this?

-Teemu

[Anonymous]

Hi
You are able to generate the XML file in the below format with tAdvancedFileOutputXML component.
    <address type="home">
      <line>line1</line>
      <line>line2</line>
    </address>
    <address type="business">
      <line>line1</line>
      <line>line2</line>
    </address>
Set address as a group element, and set line as a loop element, see

Best regards
Shong

[Anonymous]

Thanks Shong! Actually my need is to create web service request so is the solution applicable for it?

-Teemu