I want all unique array value together in one field from mongodb

Question

I am using MongoDB. and I have multiple fields in documents of one collection, which are color, style, keywords, shape, etc. and all data type is an Array. I want all the unique values of color, style, shape, keywords, etc. from all the documents.

Sample document as pr below

  "_id": "5de63ae0d88ea145cc7accb5",
  "id": "28011",
  "name": "BID 2",
  "slug": "bid-2",
  "description": "<p>Decorative details of graphic foliage interpreted in the latest colours such as black, pink, green and turquoise. The soft texture of the ceramic envelops with warmth even the coldest dish.</p>\r\n\r\n<ul>\r\n\t<li>Dishwasher and microwave safe</li>",
  "price": "0.00",
  "keywords": [
    "Kitchen",
    "cook",
    "cooking",
    "kitchens",
    "pantry",
    "kitchen room",
    "room",
    "cookhouse",
    "cookery",
    "cuisine",
    "cook room",
    "food",
    "Crockery",
    "dishware",
    "dishes",
    "plates",
    "platters",
    "stoneware",
    "bone china",
    "porcelain",
    "earthenware",
    "ironstone",
    "plate",
    "dish",
    "small dish",
    "fruit dish",
    "fruit plate",
    "",
    "dessert plate"
  ],
  "Country": [
    "Italy"
  ],
  "Shape": [
    "Round"
  ],
  "Brand": [
    "Bitossi Home"
  ],
  "Materials": [
    "Ironstone"
  ],
  "Usage": [
    "Fruit Plate"
  ],
  "Color": [
    "Pink"
  ]
  }
}

I tried with $groupby. but it's giving me unique arrays in different arrays. I want result like below

{'color' : ['blue', 'red', 'green', 'white', 'gold'],
'shape' : ['round', 'square'],
'style' : [],
'keywords' : ['room', 'kitchen']}

Ask questions with sample data, and provide what you have tried so far — Sathish, Dec 03 '19 at 10:57
@sathish please check the revised question with example document and response sample. — Yellow Digital Labs, Dec 03 '19 at 11:37

Developer · Answer 1 · 2019-12-03T12:59:40.660

here is MongoPlay Around

db.collection.aggregate([ {
                            $unwind: "$Color"
                          },
                          {
                            $unwind: "$Shape"
                          },
                          {
                            $group: {
                            _id: null,
                                color: {
                                    $addToSet: "$Color"
                                },
                                Shape: {
                                    $addToSet: "$Shape"
                                }
                           }
                         },
                         {
                           $project: {
                               _id: 0
                         }

                      ])

OR You can use this You can use Distinct for only getting unique values from defined field.

// syntax is..
             db.collection.distinct(fields,query)

// your query is..

db.collection.distinct(color,style,shape)

score 0 · Accepted Answer · answered Dec 03 '19 at 12:54

0

Can be done using addToSet and reduce

The group brings all the values into a single document.

The reduce converts the array of arrays into array

db.dimen.aggregate( 
   [ 
      { 
         "$group":{ 
            "_id":0,
            Color:{ 
               $addToSet:'$Color'
            },
            Shape:{ 
               $addToSet:'$Shape'
            }
         }
      },
      { 
         $project:{ 
            "Color":{ 
               $reduce:{ 
                  input:"$Color",
                  initialValue:[ 

                  ],
                  in:{ 
                     $concatArrays:[ 
                        "$$value",
                        "$$this"
                     ]
                  }
               }
            },
            "Shape":{ 
               $reduce:{ 
                  input:"$Shape",
                  initialValue:[ 

                  ],
                  in:{ 
                     $concatArrays:[ 
                        "$$value",
                        "$$this"
                     ]
                  }
               }
            }
         }
      }
   ]
);

answered Dec 03 '19 at 12:54

Sathish

332
4
11

I am getting the same value multiple times using this query. I want Color, Shape, etc. wise unique data. – Yellow Digital Labs Dec 05 '19 at 12:03
never mind I updated $concatArray to $setUnion and working perfect for me. Thank you. @Sathish – Yellow Digital Labs Dec 05 '19 at 12:07
It's not performing well with more then 5 lacks records. It takes around 6 seconds. Can you please help me to improve query performance? – Yellow Digital Labs Dec 10 '19 at 12:04
can you try creating index on exact fields that you are querying – Sathish Dec 11 '19 at 08:04
I already added indexes on all of them. But the same performance. – Yellow Digital Labs Dec 11 '19 at 09:14

I want all unique array value together in one field from mongodb

2 Answers2