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

waqarahmadkp's avatar
waqarahmadkp
New Member
4 years ago

based on your suggestion, i am adding a new column as follows

=Switch(True() ,
[ApplicationType] {"Duplicate", "Duplicate (R)"} "Dup",
"other"
)

however it is giving error Token RightBrace Expected.

also can there be any other drag and drop option to do so.

Anonymous's avatar
Anonymous
Not applicable
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