I am new to mongoDB and it’s really exciting.
I have a scenario where i need to group on common fields(3) span across collections and have to perform summing up all the numeric columns by column wise and all string/text columns need to make “Nan” or “Null”.
Help me to form the query…
attaching two sample collections, great regards from my side.
The common fields across the collections are, X, Y_DT and Z. and other columns either numeric, string/text.