Forum Discussion
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, 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?
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
3 Replies
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"
)
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.
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
