topic How to Append data in Talend Studio

How to Append data

Jennifer_siders — Tue, 07 Feb 2017 01:40:12 GMT

Hi,
We have a scenario wherein we have to update a field which already have a value in it. We dont want to remove/overwrite the existing value but we would like to append the value coming from a file.
Any ideas would be highly appreciated
Cheers
Jenny.

Re: How to Append data

Anonymous — Tue, 07 Feb 2017 06:23:33 GMT

Hi,
Here is an "Append" option in tfileoutputdelimited component which is used to add the new rows at the end of the file.
Let us know if it is what you are looking for.
Best regards
Sabrina

Re: How to Append data

Jennifer_siders — Tue, 07 Feb 2017 07:36:10 GMT

Hi,
Thanks for the response. However we are using to update via tsalesforceoutput* component
Cheers

Re: How to Append data

TRF — Tue, 07 Feb 2017 08:01:45 GMT

Hi Jennifer,
Can you detail a little more?
If you want to update existing records in Salesforce, just use tSalorsforceOutput* component with Update as the action.
For this, you need to query first to retrieve the corresponding record Id.
You may also use Upsert with an external Id, but in such a case, records not retrieved by Salesforce will be inserted.
Regards,
TRF

Re: How to Append data

Jennifer_siders — Tue, 07 Feb 2017 09:25:15 GMT

Hi TRF
Thank you for the response.
File Input:
Record 1:
Name: jenny
Customer Id: 100
Comments: Incorrect Phone
Record 2:
Name: jenny
Customer Id: 100
Comments: Not qualified
Now comments field is mapped to a salesforce field of type TextArea. I would like to append data coming from the file, when i use update or upsert the same is not working
Cheers
J