I want to remove duplicate based on specific column

[Muneer_Alrashdan1 (Muneer Alrashdan)]

Hi
I have excel sheet i want to remove duplicate based on specific column
• Remove duplicates based on the “Main Transaction” column, the priority is based on the “Start Transaction Time” column. keep the newer transactions

[mukeshsmart78 (MukeshMugee)]

Hi @Muneer_Alrashdan1 ,

Try this syntax

Yourdt.DefaultView.ToTable(True,“Your colum name”)

This is only filter your given column and you get the result only that column data’s

[Yoichi]

Hi,

Can you try the following expression with Assign activity?

dt = dt.AsEnumerable.GroupBy(Function(r) r("Main Transaction").ToString).Select(Function(g) g.OrderBy(Function(r) CDate(r("Start Transaction Time").ToString)).Last()).CopyToDataTable()

Regards,

[arivu96 (Arivazhagan A)]

Hi @Muneer_Alrashdan1,
Use below code to get unique value of the column

(From p in dt.Select() where( From q in dt.Select() where q("Main Transaction").Equals(p("Main Transaction")) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

Regards,
Arivu

[balupad14 (Balamurugan)]

Hi @Muneer_Alrashdan1 ,

Take a look this !!!

Remove duplicates in excel

Hi, You can use this to remove the duplicate rows Regards Balamurugan.S

UiPath Excel Remove duplicate | Multiple columns (remove duplicates)

Regards
Balamurugan.S