Hi everyone, After using Read Range to generate a data table from an excel. I am now in the assign activity, trying to get the most common string value from a column. How can I achieve this? Thanks in advance.

Find the Most Common Values in a column of Excel (DataTable)

ppr (Peter Preuss) August 20, 2020, 9:08pm 4

@Rebecca_Liao
find some starter help here. refer to dtStatistic and the log message line:
ColValueCountStatistic.xaml (9.5 KB)

1 Like

Topic		Replies	Views
Most common value in a datatable column Help studio	1	1471	April 11, 2019
How to find Common Values from Excel/DataTable Help excel	2	1486	May 16, 2018
Get the most repeated value in datatable Help activities	15	3394	January 25, 2020
DataTable with Error NullReferenceException Help	5	1484	May 12, 2019
Excel & Datatable doubt Academy Feedback	11	2546	December 27, 2019