I have a 10 stage pipeline. After stage 5 I need to “$merge” it to collection "A: and then continue with the pipeline and after stage 10 I need to “$merge” it to collection “B”. Is this possible and what is the best way to achieve it

[image] Santosh_Gonsalves: Yes, that can be done but the objective is to avoid querying the whole bunch of documents and processing them with the same logic again That was clear from the beginning. [image] Santosh_Gonsalves: You mean the second aggregation No. I mean the first aggreg…

Santosh_Gonsalves (Santosh Gonsalves) March 15, 2024, 2:20pm 9

@steevej This is resolved. Appreciate the solution!!!

1 Like

Update the aggregation output to two different collections