Forum Discussion

waqarahmadkp's avatar
waqarahmadkp
New Member
4 years ago
Solved

group/categorization

hi all. i have a column1 having approx 5000000 rows with 29 distinct text values in it. i want to group these 29 distinct under 5 categories/groups in a new column. e.g. values like oranges, mangoes...
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi waqarahmadkp ,

    You can update the formula of your calculated column as below:

    Column = 
SWITCH (
    TRUE (),
    [ApplicationType] IN { "Duplicate", "Duplicate (R)" }, "Dup",
    "other"
)

    Best Regards