Most repeated value

[#1]

Hi all,

i have to obtain the most repeated value in a field. For example :

LOAD * INLINE [

    Value

    1

    2

    3

    3

    4

    4

    4

    5

];

The most repeated value is 4. Anyone know how to do it?

Thanks in advanced

[sunny_talwar]

Try with Mode function may be

Mode(Value)

[sunny_talwar · Accepted solution]

Check for a script based example here:

What is functionality of mode function?

[cspencer3]

Mode() should do the trick!

[#5]

Great!! thanks Sunny, i lost many time trying with the funcion "for" and "if"