Join multiple collection for data aggregation
It would really helpful for creating different aggregation on multiple collection connecting them through some "key" columns. Right now it is possible only to export the 2 CSV files and then in Excel join the data.
11
votes
-
Steven Hart
commented
I agree. One way to do this natively is to run a find to return a cursor, then iterate over that cursor on another collection
-
Matthew Valdez
commented
MongoDB 3.2 has implemented $lookup https://docs.mongodb.org/master/reference/operator/aggregation/lookup/#pipe._S_lookup