Alternatively, if it’s just two rows each group, you could pivot it and then transpose based on a Mod count (1,2) of the groups. Then you can either use a select tool to split them and join them again OR you could use a formula tool to directly compare + a summarise tool to group and concat the status (Duplicate/Not duplicate). So if Not duplicate exists, then that row is not a duplicate, but if only duplicate exists, then you have your status.
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/