mapping

[#1]

PFA for attached data .

id	status	association	error_info
123	planned-in-progress	active	passed
123	planned-in-progress	issued	passed
456	planned-in-progress	issued	passed
789	planned-in-progress	active	not  serviced
789	planned-in-progress	mark-delete	not  serviced
568	planned-in-progress	active	not serviced

1 wen my id's  and status are same and association is as active and issued then my error_info shud be passed ,

2 wen wen status is planned in progress and association is issued  i want error_info shud be passed and wen association is active it shud be not serviced

Please help