Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
KKBS
Contributor
Contributor

MongoDB Output Not able to update existing Fields using _id(Object_ID) as key

Hi Everyone

My Talend Job has InputFile-->Tmap-->MongoDBOutput. As part of the job i am trying to update existing Subelement Field level values with new values using _id(ObjectID) as key.

Could you please let me know what option do i need to use.

i tried option 'set' or 'Upsert with Set'. But no records got updated.

I can't use 'Update' or upsert:since this will replaces the existing document and source and target layout is not same Source has only 10 Fields But Target collection as 50. Out of 50 Fields i need to update only 10 fields so i had to use 'set' or 'Upsert with Set'.

I appricate all the help if you could help me in this issue.

Settings inside the MongoDBOoutput that i am currently using.

Basic Settings : Bulk write & Bulk Write Size " 1000" & Action on data 'Set'

Advanced settings : GenerateJSON Document &

Ignore Service attributes for empty elements

Remove root nod.

Data node as "data" & Query node as "query"

Also i have Configure Json Tree similar to below

0695b00000mR8LSAA0.png

Labels (4)
0 Replies