topic Re: How to map a non loop element to a loop element in tXMLMap in Talend Studio

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

Anonymous — Mon, 24 Aug 2015 14:42:26 GMT

Hi,

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

Regards,

Teemu

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

Anonymous — Tue, 25 Aug 2015 10:14:16 GMT

Hi Teemu,

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

Best regards
Sabrina

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

Anonymous — Wed, 26 Aug 2015 06:51:34 GMT

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

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

Anonymous — Thu, 27 Aug 2015 13:12:48 GMT

Any ideas how to solve this?

-Teemu

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

Anonymous — Tue, 01 Sep 2015 10:34:45 GMT

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

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

Anonymous — Tue, 01 Sep 2015 12:27:17 GMT

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

-Teemu