topic Re: XML metadata with many tags with the same name in Data Quality

XML metadata with many tags with the same name

Anonymous — Sat, 16 Nov 2024 12:08:46 GMT

Hi,
I was wondering what would be the best way to create metadata of an XML file with this format:
<?xml version="1.0" encoding="utf-8"?>
<django-objects version="1.0">
<object pk="8" model="auth.user">
<field type="CharField" name="username">jd</field>
<field type="CharField" name="first_name">John</field>
<field type="CharField" name="last_name">Doe</field>
<field type="CharField" name="email">bla@bla.com</field>
</object>
<object pk="2102684" model="auth.user">
<field type="CharField" name="username">kp</field>
<field type="CharField" name="first_name">Karl</field>
<field type="CharField" name="last_name">Row</field>
<field type="CharField" name="email">karl@test.com</field>
</object>
.... etc
</django-objects>
The problem here is that the <field> tag repeats multiple times (instead of having a separate <username>, <first_name>, etc tag), which causes the default metadata mapping to only return the first occurance (username).
How can I best map this kind of data?
Thanks
koen

Re: XML metadata with many tags with the same name

Anonymous — Tue, 27 Nov 2012 10:56:27 GMT

Hi
I have replied the same question in topic:
https://community.talend.com/t5/Data-Quality-Preparation-and/Can-i-map-multiple-tag-of-xml-in-schema/td-p/88282

Re: XML metadata with many tags with the same name

Anonymous — Tue, 27 Nov 2012 11:29:14 GMT

Thanks. I ended up looping over de "object" tag and used the "@field" for the columns which worked fine. Thank you for taking the time to read. Talend is awesome, it got the job done perfectly.