db={"collection":[{"_id":"60f83d3cd66842301905aa77","id":527438,"name":"CryptoPunk #4050","asset_contract":{"name":"CryptoPunks","address":"0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb"},"traits":[{"trait_type":"type","value":"Male","display_type":null,"max_value":null,"trait_count":6039,"order":null},{"trait_type":"accessory","value":"Mohawk","display_type":null,"max_value":null,"trait_count":441,"order":null},{"trait_type":"accessory","value":"Earring","display_type":null,"max_value":null,"trait_count":2459,"order":null},{"trait_type":"accessory","value":"Frown","display_type":null,"max_value":null,"trait_count":261,"order":null}],"token_id":"4050","permalink":"https://opensea.io/assets/0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb/4050","background_color":null,"image_url":"https://lh3.googleusercontent.com/sO18rDQYhC5yIcj12RVsv31pbbsZo_2muQQbTJMQHn47EKGhnirs8mxzohm58HAZ7taBoe4pU6x1qntlExk_TtJ-","image_preview_url":"https://lh3.googleusercontent.com/sO18rDQYhC5yIcj12RVsv31pbbsZo_2muQQbTJMQHn47EKGhnirs8mxzohm58HAZ7taBoe4pU6x1qntlExk_TtJ-=s250","animation_url":null,"vault_contract":"0x269616d549d7e8eaa82dfb17028d0b212d11232a"},{"_id":"60f83d3cbc3f0161da2141f7","id":17736625,"name":"OJ Simpson","asset_contract":{"name":"Hashmasks","address":"0xc2c747e0f7004f9e8817db2ca4997657a7746928"},"traits":[{"trait_type":"Character","value":"Male","display_type":null,"max_value":null,"trait_count":8659,"order":null},{"trait_type":"Mask","value":"Doodle","display_type":null,"max_value":null,"trait_count":2187,"order":null},{"trait_type":"Eye Color","value":"Dark","display_type":null,"max_value":null,"trait_count":7419,"order":null},{"trait_type":"Item","value":"No Item","display_type":null,"max_value":null,"trait_count":14533,"order":null},{"trait_type":"Skin Color","value":"Dark","display_type":null,"max_value":null,"trait_count":3784,"order":null},{"trait_type":"Token ID","value":3535,"display_type":"number","max_value":null,"trait_count":0,"order":null},{"trait_type":"Background","value":"Doodle","display_type":null,"max_value":null,"trait_count":5538,"order":null}],"token_id":"3535","permalink":"https://opensea.io/assets/0xc2c747e0f7004f9e8817db2ca4997657a7746928/3535","background_color":null,"image_url":"https://lh3.googleusercontent.com/NZQu7CNjgJ_1uhbUVwEb-14rZPJmPCaqaXy0qnUpgm5Qll0BvmmF7tPMjBhFH6ZZp_qzOPxHi0NFmRkOjHoBQ0BODcWI8NlyBXLu","image_preview_url":"https://lh3.googleusercontent.com/NZQu7CNjgJ_1uhbUVwEb-14rZPJmPCaqaXy0qnUpgm5Qll0BvmmF7tPMjBhFH6ZZp_qzOPxHi0NFmRkOjHoBQ0BODcWI8NlyBXLu=s250","animation_url":null,"vault_contract":"0xc7a8b45e184138114e6085c82936a8db93dd156a"}],"dummy":[{}]}

db.collection.aggregate([{"$set":{"traits":{"$map":{"input":"$traits","as":"t","in":{"$reduce":{"input":{"$map":{"input":{"$objectToArray":"$$t"},"as":"m","in":["$$m.k","$$m.v"]}},"initialValue":{},"in":{"$let":{"vars":{"type_value":"$$value","ta":"$$this"},"in":{"$let":{"vars":{"key":{"$arrayElemAt":["$$ta",0]},"value":{"$arrayElemAt":["$$ta",1]}},"in":{"$switch":{"branches":[{"case":{"$eq":["$$key","value"]},"then":{"$mergeObjects":["$$type_value",{"value":"$$value"}]}},{"case":{"$eq":["$$key","trait_type"]},"then":{"$mergeObjects":["$$type_value",{"type":{"$replaceAll":{"input":{"$toLower":"$$value"},"find":" ","replacement":"_"}}}]}}],"default":"$$type_value"}}}}}}}}}}}},{"$lookup":{"from":"dummy","let":{"traits":"$traits"},"pipeline":[{"$set":{"traits":"$$traits"}},{"$unwind":{"path":"$traits"}},{"$replaceRoot":{"newRoot":"$traits"}},{"$group":{"_id":"$type","values":{"$push":"$value"}}},{"$set":{"type":"$_id"}},{"$project":{"_id":0}},{"$replaceRoot":{"newRoot":{"$cond":[{"$eq":[{"$size":"$values"},1]},{"$arrayToObject":{"$let":{"vars":{"pair":[["$type",{"$arrayElemAt":["$values",0]}]]},"in":"$$pair"}}},{"$arrayToObject":{"$let":{"vars":{"pair":[["$type","$values"]]},"in":"$$pair"}}}]}}}],"as":"traits"}},{"$set":{"traits":{"$mergeObjects":"$traits"}}}])