topic Re: [resolved] How can I insert data into a 1 to many field in Talend Data Catalog

[resolved] How can I insert data into a 1 to many field

Anonymous — Fri, 14 Nov 2014 10:05:18 GMT

Hi
I have an entity which looks like this:
<Person>
<FirstName></FirstName>
<LastName></LastName>
<Address></Address>
</Person>
The address field is one too many.
I have two persons who I want to insert:
<Person>
<FirstName>Dries</FirstName>
<LastName>Nuyts</LastName>
<Address>address1</Address>
<Address>address2</Address>
</Person>
<Person>
<FirstName>John</FirstName>
<LastName>Jackson</LastName>
<Address>address3</Address>
<Address>address4</Address>
<Address>address5</Address>
</Person>
How can I achieve this?
Thanks

Dries

Re: [resolved] How can I insert data into a 1 to many field

Anonymous — Fri, 14 Nov 2014 10:23:49 GMT

Hi,
Assuming "FirstName" and "LastName" is the composed key of your record, you may send:
<Person>
<FirstName>John</FirstName>
<LastName>Jackson</LastName>
<Address>address3</Address>
<Address>address4</Address>
<Address>address5</Address>
</Person>
using a tMDMOutput. This will put address1, address2 and address3 in the record. Note here the "Address" elements contains the full list of address. So if you have this record currently in database:
<Person>
<FirstName>John</FirstName>
<LastName>Jackson</LastName>
<Address>address1</Address>
</Person>
The Address "address1" will be modified to "address3".

Re: [resolved] How can I insert data into a 1 to many field

Anonymous — Fri, 14 Nov 2014 10:31:31 GMT

Hi Fhaulme
Thanks for your reply!
It seems that i missed something in the online documentation.
I've resolved the issue by selecting "Use Partial Update" and by setting the following settings:
Pivot: "/Person/Address"
Key: "/Child"
Kind regards
Dries

Re: [resolved] How can I insert data into a 1 to many field

Anonymous — Fri, 14 Nov 2014 11:25:41 GMT

Hi,
You may use partial update to update (append) elements to a existing address elements. If you wish to update the whole collection at once, the solution I proposed should work fine.

Re: [resolved] How can I insert data into a 1 to many field

Anonymous — Fri, 14 Nov 2014 13:34:44 GMT

Hi Fhualme
Is it possible to use your solution when the amount of addresses varies? Lets say one person has 1 address and another has 20 addresses.
Kind regards
Dries