August 15, 2023

Partial update with Overwrite enabled or disabled – Docs for ESB 6.x

Partial update with Overwrite enabled or disabled

The following two examples explain how to add some elements to an existing item
(entity) with multi-occurrence elements (attributes) and then update the newly added
elements based on the content of a source XML stream.

Given an existing item as follows:

Example 1: If you want to add two Child items to the existing item, then the Xpath you
enter in the Pivot field must read as follows:
/Person/Children/Child where the Overwrite check box is cleared, and the Key field is set to /Name. Note that the Child element is of complex type, and needs to be
identified with the Key field. Moreover, you need
to provide the source XML stream as follows:

In this case, the two child items Child [k2]
and Child [k3] will be added, and you will get
the following result:

Example 2: If you want to change the names of the
two child items Child [k2] and Child [k3], then the Xpath you enter in the Pivot field must read as follows:
/Person/Children/Child where the Overwrite check box is selected, and the Key field is set to /Name. Moreover, you need to
provide the source XML stream as follows:

In this case, the names of the two child items Child
[k2]
and Child [k3] will be
updated, and you will get the following result:


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x