Database
[{"name":[{"name.x":[{"_id":"607e7fcca57aa56e2a06b57b","name":"abc","type":"123"}],"_id":{"$oid":"62232cd70ce38c5007de31e6"},"qty":"1.0","Unit":"pound,lbs"},{"name.x":[{"_id":"607e7fcca57aa56e2a06b430","name":"xyz","type":"123"}],"_id":{"$oid":"62232cd70ce38c5007de31e7"},"qty":"1.0","Unit":"pound,lbs"},{"name.x":[],"_id":{"$oid":"62232cd70ce38c5007de31e7"},"qty":"1.0","Unit":"pound,lbs"}]}]
Query
db.collection.update({},[{$set:{name:{$filter:{input:"$name",cond:{$ne:[{$getField:{field:"name.x",input:"$$this"}},[]]}}}}}],{multi:true})