Hello all,
I would like to get the count of values from Column 1
input
to get output like this:
output
Thanking you
Hello all,
I would like to get the count of values from Column 1
input
to get output like this:
output
Thanking you
Hey @Yugal_Raju ,
Please check this workflow
CountOccurance.zip (2.5 KB)
Regards,
@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,
@Yugal_Raju ,
Can you open it now?
CountOccurance.xaml (12.8 KB)
Regards,