Merge Duplicate And calculate the Number of Duplicate

[Krishan_Rapswal]

1. Merge the Duplicate Rows
2. Calculate the number of duplicate rows
3. average of numbers ( Rating )

While Merging all the other Value are deleting
How to do it can some give some kind of Hint

[Gangadhar_Athili]

DT.asenumearble.groupby(function(r) r(“author”).Tostring).select(Function(g) DT.clone.loaddatarow({g.key,g.count,g.avg(function(a) CDbl(a(“Rating”)))},False).Copytodatatable

[Krishan_Rapswal]

Error

[Suraj_B_Shetty (Suraj)]

Hi @Krishan_Rapswal

Give a try to this.
GroupBy.xaml (12.7 KB)

[Krishan_Rapswal]

Same Value Coming Up

[Suraj_B_Shetty (Suraj)]

Hi @Krishan_Rapswal
I’m getting this ouput. Can u share screen shot. Use this input file and check.
Test.xlsx (8.4 KB)

[Krishan_Rapswal]

Books List.xlsx (14.3 KB)

This is the Excel File if you run this code the output is come Same as Input

[vishal.kp (vishal)]

Hi @Krishan_Rapswal ,

Refer to the attached workflow to get an idea on your use case.
AuthorGroupBy.xaml (9.2 KB)

[Suraj_B_Shetty (Suraj)]

Hi @Krishan_Rapswal

Verify the output

Books List.xlsx (16.3 KB)

[Krishan_Rapswal]

yes Correct

[Suraj_B_Shetty (Suraj)]

GroupBy.xaml (13.5 KB)

[Krishan_Rapswal]

thank you for the output