Hello, I’ve seen many versions of solutions out there for this, but all appear to be overly complicated for what I need. I have an excel file of addresses with columns “Address”, “City”, State", “Zip”, “Date”. I want to delete all duplicates within column “Address” keeping the one with the most r…

[grafik] give a try on deleting the assign activity and rebuild it from new (we do it when the validation message is not making sense) - feel free to run the xaml stepwise for triggering a compliation before rebuilding. ensure following: [grafik]

[image] Brett_Johnson: I’ve seen many versions of solutions out there for this, but all appear to be overly complicated for what I need. What had you seen so far. We can achieve it e.g. with a Grouping the data (Non LINQ / LINQ approaches) and processing the the group memebrs (Filtering to th…

Whenever to implement any of the solutions that have a GroupBy function, I get this: [image] How do I fix this? Thanks.

give a try on the query syntax: dtOutput = (From d in dtInput.AsEnumerable Group d by k=d("Adress").toString.Trim into grp=Group Select r = grp.First()).CopyToDataTable

I didn’t have the System.Linq nor System.Linq.Expressions namespaces imported. Thanks!

So please do it and give us feedback if the issue is resolved. Thanks

Delete Duplicate Excel Rows Based On One Column

Help Studio

Brett_Johnson (Brett Johnson) November 3, 2021, 4:22pm 7

Similar error which I’ve seen before in my trials thus far: GroupBy not accessible in this context.

Topic		Replies	Views
Remove Dublicate Rows based on a column Studio datatable , excel , activities , question	11	3176	August 22, 2021
Filter by duplicate column and copy the row in Excel Help excel , activities , studio	2	1912	October 29, 2018
Delete Duplicates in a Column in Excel sheet Studio datatable , excel , activities , question	11	1674	May 15, 2020
Identify if there is any duplicate values in excel column Studio studio , question , activities_panel	16	1365	February 28, 2023
Remove duplicate rows Studio	13	4002	September 2, 2020

Delete Duplicate Excel Rows Based On One Column

Related topics