I have a Datatable which has Rows like this: [image] I want to convert this table to a new table that contains unique row Names and their counts that appeared in the previous table, like this: [image]

giving some starter help: Prepare with a build datatable activity the target column structure by configuring an empty datatable with the two cols: PromLang, Count - dtResult Assign activity LHS: dtResult RHS: (From d in YourDataTableVar.AsEnumerable Group d by k=d("PrimaryLanguague").toString.…

How to Restructure a Datatable to convert from Row to Row and Row Count (Group By Count Operation)?

Help Activities

ppr (Peter Preuss) December 3, 2021, 10:52am 2

Topic		Replies	Views
Get unique rows and their count as a datatable Something Else datatable , studio , feedback	5	1439	February 12, 2022
DataTable Streamlining Activities database , uiautomation	2	1022	September 1, 2021
DataTable : Is there a way to get the result of 'After'? Activities excel , activities , question	4	562	February 23, 2023
Group Datatable by Value and Joining Row values Activities uiautomation	3	752	March 28, 2023
Combining Datarows based on Unique Columns Activities datatable , excel , activities , studio , question	9	1022	July 31, 2021

Most Active Users - Yesterday
Logesh_Velu
ben.smith
sharazkm32
More details...

How to Restructure a Datatable to convert from Row to Row and Row Count (Group By Count Operation)?

Related topics