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

Talend Update to Salesforce: Deletes Data

Hello everyone,

 

I'm new to Talend and I try to use it in order to update data in my Salesforce org. In my Salesforce org I have a custom date field on each record that is connected to a custom ID. I need to update only a few of these records everyday and adjust only the custom date. Basically I pull all data out of Salesforce (who have the custom ID) and use tmap to match the new dates that I get in a xlsx to the affected records and I only want to update those.

 

However when I run my job, Talend updates all exported records and depletes the date in records that do not have a new date in the xlsx. So the records I really want to update are working fine, but I don't see why he depletes all dates in the other records that are not part of the update - process. I lose all my previous custome dates in the process. The job depletes all dates but the ones that are in the xlsx to update. 
What I need is that the job really only updates the date fields I get delivered in the .xlsx and that he ignores the ones that have a value in them but are not being updated on that day.

 

0683p000009LscZ.png

 

 

0683p000009LsYy.png 

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello,

Do you want to just update the changed custom dates? If so, you can set the "Catch lookup inner join reject" as true and the output should be the changed data.

0683p000009Lt2g.png

Best regards

Sabrina