remove some dupes but not all

kpmg_lc_analyst

I have a situation where I need to remove some duplicates from a dataset. For example, i need to remove 4 of the 8 records that have the same record ID.  Is there a better way to do this than simply filtering to the record ID and using the sample tool? I'm trying to figure out the best way to do this.  Obviously the unique tool won't work. Thanks in advance. 

record id	count should be	count is
1	2	4
2	4	8
3	4	8
4	8	16

NicoleJohnson

Hmmm. Could you add a second level "RecordID2" (using a multi-row tool) to add a RecordID within each RecordID grouping... then join the desired count by original RecordID... then filter out any "RecordID2" that is greater than the desired count?

RecordID	RecordID2	DesiredCount	Included when filtering for RecordID2 <= DesiredCount?
1	1	2	Yes
1	2	2	Yes
1	3	2	No
1	4	2	No
2	1	4	Yes
2	2	4	Yes
2	3	4	Yes
2	4	4	Yes
2	5	4	No
2	6	4	No
2	7	4	No
2	8	4	No