Hello all, I need your help please. I have a table that contains article numbers in column F, which can occur more than once. For the subsequent process I need the data formatted. This means that I only need the article number once and the complete total in column G. How can I map this? As an exa…

Hi @NHoe Try this expression and increment the column index based on the column count grp.First()(Index) (From d In DT_Input.AsEnumerable Group d By k=d(“Product_Vendor_Number”).toString.Trim Into grp = Group Let nj = grp.Sum(Function (x) CDbl(x(“QTY_Requested_for_Return”).toString.Trim)) Let ra …

Remove duplicates from duplicates

Help Studio

Gokul001 (Gokul Balaji) November 4, 2022, 7:26am 3

Check out this Sample XAML file for your reference @NHoe

GroupBySumBuildDt.xaml (8.1 KB)

Regards
Gokul

How to get output as unique rows by comparing two columns using LINQ query

Topic		Replies	Views
Removing duplicates based on one Column Forum question	12	1547	October 11, 2022
Remove duplicates comparing only 2 columns in excel Studio studio , question , activities_panel	7	1158	October 2, 2022
Remove duplicate from data table based on filter Studio activities , studio , linq	7	768	December 30, 2022
Remove Duplicates with LinQ Help studio	17	17452	October 29, 2018
Keep structure of table as it is and take distinct row Help excel , activities	10	952	March 11, 2020

Most Active Users - Yesterday
Anil_G
A_Learner
19learningcurve
SorenB
kulasinghasampath
More details...

Remove duplicates from duplicates

Related topics