[{"_id":1,"UniqueID":"111","Search_Criteria":"NameOfOrg","Searched_value":"IBM","UserNavPage_YN":"Y","PDF_DL":"N","Excel_DL":"Y","Id_of_entity":"121212","ProcessedYN":"N",},{"_id":2,"UniqueID":"111","Search_Criteria":"NameOfOrg","Searched_value":"IBM","UserNavPage_YN":"Y","PDF_DL":"Y","Excel_DL":"N","Id_of_entity":"121212","ProcessedYN":"N",},{"_id":3,"UniqueID":"222","Search_Criteria":"NameOfOrg","Searched_value":"Tesla","UserNavPage_YN":"Y","PDF_DL":"N","Excel_DL":"N","Id_of_entity":"2121","ProcessedYN":"N",},{"_id":4,"UniqueID":"222","Search_Criteria":"NameOfOrg","Searched_value":"Tesla","UserNavPage_YN":"Y","PDF_DL":"N","Excel_DL":"Y","Id_of_entity":"2121","ProcessedYN":"N",}]

db.collection.aggregate([{$group:{_id:"$UniqueID","Search_Criteria":{$addToSet:"$Search_Criteria"},"Searched_value":{$addToSet:"$Searched_value"},"UserNavPage_YN":{$addToSet:"$UserNavPage_YN"},"PDF_DL":{$addToSet:"$PDF_DL"},"Excel_DL":{$addToSet:"$Excel_DL"},"Id_of_entity":{$addToSet:"$Id_of_entity"},"ProcessedYN":{$addToSet:"$ProcessedYN"},}},{$addFields:{"UniqueID":"$_id","Search_Criteria":{$arrayElemAt:["$Search_Criteria",0]},"Searched_value":{$arrayElemAt:["$Searched_value",0]},"UserNavPage_YN":{$cond:{if:{$or:[{$and:[{$eq:[1,{$size:"$UserNavPage_YN"}]},{$eq:["Y",{$arrayElemAt:["$UserNavPage_YN",0]}]}]},{$gt:[1,{$size:"$UserNavPage_YN"}]}]},then:"Y",else:"N"}},"PDF_DL":{$cond:{if:{$or:[{$and:[{$eq:[1,{$size:"$PDF_DL"}]},{$eq:["N",{$arrayElemAt:["$PDF_DL",0]}]}]},{$gt:[1,{$size:"$PDF_DL"}]}]},then:"N",else:"Y"}},"Excel_DL":{$cond:{if:{$or:[{$and:[{$eq:[1,{$size:"$Excel_DL"}]},{$eq:["Y",{$arrayElemAt:["$Excel_DL",0]}]}]},{$gt:[1,{$size:"$Excel_DL"}]}]},then:"N",else:"Y"}},"Id_of_entity":{$arrayElemAt:["$Id_of_entity",0]},"ProcessedYN":{$arrayElemAt:["$ProcessedYN",0]},}},{$project:{_id:0}}])