tSalesforce output - upsert key column (QUESTION)

Ryszard_Rogalski — Sat, 16 Nov 2024 01:39:34 GMT

Dear All,

I have a question about tSalesforce output - upsert key column.

I want to know how exactly does it work.

I did some research and I found out that it tries to match the UpsertKeyColumns between the orgs, but when the first org UpsertKeyColumn is empty - the value is taken from the Id field by default (so it compares org1.Id and org2.UpsertKeyColumn field).

Am I thinking right?

Thank you in advance.

Edit:

I had mapping inside the tMap, that fills in the UpsertColumn so it turns out that UpsertMatching is being done on temporary created records inside tMap, not on records from previous org.

Re: tSalesforce output - upsert key column (QUESTION)

manodwhb — Mon, 17 Aug 2020 14:38:47 GMT

@Ryszard Rogalski ,it will do update based on the key column,which you can change .

check the below link.

https://help.talend.com/reader/~JrHURluxR5dMtQmHpZHGg/L7v6Y9bUV7~yjGvzEfBY7A

Thanks,

Manohar

topic Re: tSalesforce output - upsert key column (QUESTION) in Talend Studio

tSalesforce output - upsert key column (QUESTION)

Re: tSalesforce output - upsert key column (QUESTION)