Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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