Most common value in a datatable column

Hi,

I’m trying to figure out the best way to get the most common value in a datatable column. If I were to do this in SQL I’d use something like

SELECT top 1 [COLUMNNAME]
FROM TABLENAME
where len([COLUMNNAME])>1
GROUP BY [COLUMNNAME]

I’ve had a look at LYNC and some of the array filters but not managed to find a way. Anyone any ideas?

Thanks in advance

Hi @MichaelT,

Please refer this post it might help you
Fetch the repeated string from excel cell