Count the occurrences of values from excel columns

[Yugal_Raju]

Hello all,

I would like to get the count of values from Column 1

input

to get output like this:
output

Thanking you

[Jithesh_R (Jithesh Karkera)]

Hey @Yugal_Raju ,
Please check this workflow
CountOccurance.zip (2.5 KB)

Regards,

[Yugal_Raju]

Hello I’m getting document invalid error. Is there any package that needs to be installed ?

[Jithesh_R (Jithesh Karkera)]

@Yugal_Raju ,
Please refer this screenshot
Read range data table is InputDT

DT_Output =

(
From row In InputDT
Group row By a=row("Column1").ToString.Trim Into grp=Group
Let c=grp.Count
Select DT_Output.Rows.Add({a,c})
).OrderBY(Function(x) x("Column1").ToString.Trim).CopyToDataTable

DT_UniqueValues = InputDT.DefaultView.ToTable(True,"Column1")

DT_FinalOutput =

(
From x In Enumerable.Range(1,DT_Output.Columns.Count-1)
Let ra = DT_Output.AsEnumerable.Select(Function (d) d(x)).ToArray
Select DT_FInalOutput.Rows.Add(ra)
).CopyToDataTable

Regards,

[Jithesh_R (Jithesh Karkera)]

@Yugal_Raju ,
Can you open it now?
CountOccurance.xaml (12.8 KB)

Regards,

[ppr (Peter Preuss)]

myDict =

dtData.asEnumerable.GroupBy(Function (x) x("Column1").toString.Trim).ToDictionary(Function (x) x.Key, Function (x) x.Count)

myDataTable =
JArray.FromObject({myDict }).toObject(Of DataTable)

Ensure the following: