How to Append data

[Jennifer_siders]

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.

[Anonymous]

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

[Jennifer_siders]

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

[TRF]

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

[Jennifer_siders]

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