Most common
Abstract
Reduce the number of unique values in a data set.
Keeps the top common values in any number of selected columns. Changes the remaining values to a label you specify.
When to use this tool
Use when you want to reduce the number of unique values in a data set.
Usage example
Let's say you had a data set with 10 unique values in a column. If you type 5 in the Amount of values field, the tool keeps all records for the five most common values. Any values outside of the top five are changed to the new value you type in the Other label field.