Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] tMDMOutput - Update only one element in the Entity with primary key

Hi All,

I have a simple job to update the person information in the MDM, With this job I am updating the only title of the person using id and title elements in the tMDMOutput. Its updating fine but, its also updating other fields (prefix, firstname, lastname, suffix, version) as null.
Person Entity :
--------------------
id - primary key
prefix
firstname
lastname
suffix
title
version

So that means I need to pass all other fileds, even if I update only one field ?
I also tested with checking the "Is Update" check box on the tMDMOutput.
Can anyone have the same issue, I am using the Version 5.2.1
Thanks
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi ramesh.nim,
Just remove the XML elements you don't want to update in the tMDMOutput, and keep only the Id + the title.
To do so, double-click on the tMDMOutput, right-click on the useless elements and select 'Delete'.
I'm assuming that the 'Is Update' checkbox is enabled in the component.
Regards,
Cyril
0683p000009ME1i.png 0683p000009ME1n.png

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi ramesh.nim,
Just remove the XML elements you don't want to update in the tMDMOutput, and keep only the Id + the title.
To do so, double-click on the tMDMOutput, right-click on the useless elements and select 'Delete'.
I'm assuming that the 'Is Update' checkbox is enabled in the component.
Regards,
Cyril
0683p000009ME1i.png 0683p000009ME1n.png
Anonymous
Not applicable
Author

Hey Cyril,
Thanks for the quick answer, I tried according to your steps and it is working.
:cool:
Ramesh