Skip to main content

Varicent ELT Help Center

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.