Select first three records in each cluster


After running a Find Duplicates step at individual level I can see that we have many contact names for some business, so I want to cap these to three contacts for each business address.

I'm thinking I should run another Find Duplicates step with the Household step setting to get clusters of businesses, but from there I'm not sure how to select just three from each cluster. In SQL Server I have used row_number over partition to achieve a similar goal, does anyone know how I might do this in Aperture please?




Sign In or Register to comment.