Connect to MongoDB using specific View


I have been combining multiple MongoDB Collections using lookup aggregations in the MongoDB Compass. The result is a view that contains the data as I want it.
Though I cant select it in the Knime MongoDB Node. Is there any command I can use in the query textbox that would import a view instead of the collection? Is there any other way to archieve this?

Thanks in advance!

Okay, this is solved by just putting an “$out” step at the end of the Aggregation. Then it creates a new Collection that Knime can work with.


Hi @splush -

Welcome to the forum, and thanks much for posting your solution!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.