How do I do an only unique on 2 fields without using the only unique tool by crew?
Looking at the logic behind the Only Unique macro contains your answer. If you use a unique tool followed by another unique tool connected to the D anchor, join that back to the U anchor in the first unique tool and then only look at the L anchor from the join tool will give you your answer. You will want to make sure that the same selections are made in both unique tools and that the join is joining on the fields that are being uniqued on as well.
Hi @clarrock
Here's another way to do it.
Group by the unique fields and count the number of occurrences of each combination. Select the ones that only appear once and then join back to the original data.
Dan
Step 1: UNIQUE
step 2: join (same values as unique) the unique output to the duplicate output from the join tool
Left Output anchor are truly unique records
cheers,
mark
