Delete me thanks

Help Activities
, ,
1

Hi , It’s possible if in my excel i got mulitple duplicate rows (see image) including bringing the column name from original to duplicated ? Under the same excel file
After that i want it to email me notifed me that i have a few duplicates too. How do i do that :slight_smile: ? Thanks

image
image1354×794 25.4 KB

2

Hi,

Hope the following sample helps you.

image
image770×693 21.1 KB 

arrDr=dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r(0).ToString,r(1).ToString)).Where(Function(g) g.Count>1).Select(Function(g) g.First).ToArray

Sequence1.xaml (8.1 KB)

Regards,

4

Hi,

Can you try to install/upgrade the latest version of UiPath.Excel.Activities package from ManagePackage?

Regards,

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.