Processing Xml messages and converting in struct format

Anonymous — Sat, 16 Nov 2024 08:29:18 GMT

Hi,

I have xml below i want to process the xml using Talend and i want output to be in below expected struct format,so that i can create hive tables on this struct format.

<flighttic>
<pid>54846515522</pid>
<amount>2511</amount>
<person_details>
<person>
<fname>jakka</fname>
<lname>dilip</lname>
<flyinf0>
<fly>
<supplier>ETHIAD</supplier>
<date>2017/3/20 11:45 </date>
<mealcode>25</mealcode>
</fly>
<fly>
<supplier>American airlines</supplier>
<date>2017/3/21 22:45 </date>
<mealcode>19</mealcode>
</fly>
<fly>
<supplier>southwest</supplier>
<date>2017/3/23 14:45 </date>
</mealcode>
</fly>
<fly>
<supplier>southwest</supplier>
<date>2017/3/23 18:30</date>
<mealcode>25</mealcode>
</fly>
</flyinfo>
</person>
</person_details>
</flighttic>

expected output ::

pid	amount	fname	lanme	supplier	date	mealcode
5.48E+10	2511	jakka	dilip	ETHIAD\|American airlines\|southwest\|southwest	2017/3/20 11:45\|2017/3/21 22:45\|2017/3/23 14:45\|2017/3/23 18:30	25\|19\|\|25

Re: Processing Xml messages and converting in struct format

Anonymous — Thu, 29 Mar 2018 09:41:19 GMT

Hi,

Do you have a free Talend version ? Or a subscription version ? In case it is a subscription version, does your version include Data Mapper ?

Eric

Re: Processing Xml messages and converting in struct format

Anonymous — Fri, 30 Mar 2018 15:30:12 GMT

I am using Talend open studio for big data

topic Processing Xml messages and converting in struct format in Talend Studio

Processing Xml messages and converting in struct format

Re: Processing Xml messages and converting in struct format

Re: Processing Xml messages and converting in struct format