How do I use MongoDB aggregation to remove empty "" strings in value v array?

Question

I have the following MongoDB objects which I have first transformed into key-value k-v pairs using $objectToArray and $split. How do I remove the empty string "" from the value v array? Thanks!

{ 
    "_id" : ObjectId("5e9ecf782980434d78120a49"), 
    "data_kv" : [ { "k" : "U1", "v" : [ "", "", "University", "", "", "of", "", "", "Australia", "", "" ] } ] 
}
{   
    "_id" : ObjectId("5e9ecf7f2980434d78120a4a"), 
    "data_kv" : [ { "k" : "U2", "v" : [ "", "", "University", "of", "", "", "", "", "Australia", "", "" ] } ] 
}
{ 
    "_id" : ObjectId("5e9ecf8a2980434d78120a4b"), 
    "data_kv" : [ { "k" : "U3", "v" : [ "", "", "University", "", "", "of", "", "", "", "Sweden", "", "" ] } ] 
}

Ashh · Accepted Answer · 2020-04-21 11:36:34Z

1

You can use below aggregation

db.collection.aggregate([
  { $project: {
    data_kv: {
      $map: {
        input: "$data_kv",
        as: "kv",
        in: {
          k: "$$kv.k",
          v: {
            $filter: {
              input: "$$kv.v",
              cond: { $ne: ["$$this", ""] }
            }
          }
        }
      }
    }
  }}
])

MongoPlayground

answered Apr 21, 2020 at 11:36

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yi Xiang Chong Over a year ago

Thanks @Ashh another great answer by you

Collectives™ on Stack Overflow

How do I use MongoDB aggregation to remove empty "" strings in value v array?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related