Group Longtail Values

Description

This Activity groups the values other than those in the allow list in the specified column with the replacement value.

Input

Data only

Output

Transformed Data

---

Configuration Fields

1. Column Name Specifies the column list for grouping.
2. Allow List List of allowed values.
3. Replacement Value Value to replace those not in the allow list.

---

Sample Input

product_id	product_name	brand_names
P001	Smartphone	Apple, Samsung, Google
P002	Laptop	Dell, HP, Lenovo
P003	Headphones	Bose, Sony, Sennheiser
P004	TV	LG, Samsung, Sony
P005	Smartwatch	Fitbit, Garmin, Apple

Sample Configuration

---

Sample Output

product_id	product_name	brand_names
P001	Smartphone	Apple, Samsung, Google
P002	Others	Dell, HP, Lenovo
P003	Headphones	Bose, Sony, Sennheiser
P004	Others	LG, Samsung, Sony
P005	Others	Fitbit, Garmin, Apple