Hi everyone . I have datatable in excel file as below. I want to remove the first row if it has same value at 2 columns “name” and “code” In below picture, it will remove row ( ajay , AA, 20 ) How to do that? Thanks in advance! [image]

BTW in your code, If you had just changed 0 to 1 then it would have worked, like below (From roww In table.AsEnumerable() Group By id=New With {key .i=roww.item("code"), key .d=roww.item("name")} Into gg=Group Select gg(1)).copytodatatable

Remove row if 2 column have same value

Help

Mr.H December 21, 2020, 12:25pm 7

I have found solution via the link : Remove duplicate rows - Build / Studio - UiPath Community Forum

Thanks you!

1 Like

Topic		Replies	Views
Remove duplicate row if same value at one column and another column confirm condition Academy Feedback academic_alliance , question	10	1717	July 30, 2021
How to Remove Duplicate Row If the Value from two Columns matched Activities excel	5	2368	March 13, 2022
Remove duplicate rows based on identical values in two columns Studio	2	2827	September 10, 2020
DataTable - Remove Duplicate Row Help datatable , excel , activities , question	11	8614	December 1, 2019
Delete duplicate row if one column contain certain special string Academy Feedback academic_alliance , question	5	1294	August 23, 2021

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Remove row if 2 column have same value

Related Topics