How to Append data

How to Append data

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.
Moderator

Re: How to Append data

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: How to Append data

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

Re: How to Append data

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

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