[resolved] Complex XML structures to MySQL

Anonymous — Tue, 19 Aug 2014 15:05:52 GMT

Hi guys,
I have some XML files that come in a format like this:

<entry>
   <lastName>ORIGINAL NAME</lastName>
   <akaList>
      <aka>
         <lastName>AKA NAME</lastName>
      </aka>
   </akaList>
   <addressList>
      <address>
         <street>STREET 1</street>
         <country>NEVERLAND 1</country>
      </address>
      <address>
          <street>STREET 2</street>
          <country>NEVERLAND 2</country>
      </address>
   </addressList>

I need to put these XML files into a database table with name, address, country columns. The problem: I need a separate row with name, address, country for EVERY name (original name and aka. name). For this example it would look like:
name;address;country
ORIGINAL NAME; STREET 1;NEVERLAND 1;
ORIGINAL NAME; STREET 2;NEVERLAND 2;
AKA NAME;STREET 1;NEVERLAND 1;
AKA NAME;STREET 2;NEVERLAND 2;
I've tried solving this using tFileInputXML, but I don't know if that is even possible with a single component. Do you guys have any idea how to do that?
Thanks in advance and greetings from Vienna
Hannes

Re: [resolved] Complex XML structures to MySQL

Anonymous — Thu, 21 Aug 2014 13:01:26 GMT

topic Re: [resolved] Complex XML structures to MySQL in Talend Studio

[resolved] Complex XML structures to MySQL

Re: [resolved] Complex XML structures to MySQL