group/categorization

[waqarahmadkp]

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, cherry is represented as fruits in new column.

values like car, bicycle, bus is represented as vehicle in new column.

how i can achieve this?

[amitchandak]

@waqarahmadkp , You need to create a new column using switch

Switch( True() ,

[column] in {"1", "2", "3"} , "Cat1",

[column] in {"3", "4", "5"} , "Cat2",

"Cat3"

)

[waqarahmadkp]

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 · Accepted solution]

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