Help with an expression

[#1]

Hello.

I need to group clients by product category. For that i have a straight table with ID in first column, concatenated categories  in the second, and in the third column i need the name of the category which occurs most in the second column.

How do i find the rank of eatch CatName in column 2 (by row, not column) and display the one with highest rank in column 3?

Client	concat(CatName,',')	Group
1	Cat1,Cat1,Cat2,Cat3	Cat1
2	Cat1,Cat2,Cat2	Cat2
3	Cat1,Cat2,Cat3
4	Cat1,Cat1,Cat1,Cat2	Cat1
5	Cat1,Cat2,Cat3;cat3	Cat3

Thanks in advance.

[#2 · Accepted solution]

Hi,

For that we have a function which returns the most occurring value. The function name is mode().

in your scenario you can use it as mode(CatName) in your third column.

..

Ashutosh

[#3]

Thank you. Your reply was quick and correct I had no idea this sort of function existed.