If you grouped by id, you should have id, name, value. Group by id before you concatenate.
Summarize with group by concatenate-value and then add a count. When you find rare occurrences, you can join back to id, concat-value to find the ids to flag.
If I were near a computer I would show you what I'm thinking of more clearly. Thanks for working with me to help you.
Sent from my iPhone
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
to my youTube channel.