MongoDBOutput replaces existing documents, how to $set ?

One Star

MongoDBOutput replaces existing documents, how to $set ?

Hi,
I would like to update documents y my Mongo Collections, the problem is if I use the "update" or "upsert" mode of the component I lose all the existing fields of the document. It actually acts as a "replace" mode. 
How can I use the equivalent of the "$set" command so that the existing fields are not losts ?
Thanks,
Maxime
One Star

Re: MongoDBOutput replaces existing documents, how to $set ?

Well, it seems there is currently no way to use $set functionnality...
https://jira.talendforge.org/browse/TDI-28878
Do you have any roadmap for this? Or workaround?
Moderator

Re: MongoDBOutput replaces existing documents, how to $set ?

Hi,
Could you please vote for this new feature jira issue?
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.
One Star

Re: MongoDBOutput replaces existing documents, how to $set ?

Hi,
Could you please vote for this new feature jira issue?
Best regards
Sabrina

Hi,
Can we use the tMongoDBRow to achieve this?
Can we write the query and get it done as a workaround? Any issue with it?