Duplicates Values

[nikhil.patil]

find the duplicate values from column in excel and if excel is empty then code is still running

[lakshman (Ganta lakshman)]

@nikhil.patil

Sorry I didn’t get you. Can you please tell more details about the issue for better understanding.

[Dhanush_Naik1 (Dhanush Naik)]

Hi,

Can you provide sufficient input and expected output.

Regards,
Dhanush

[THIRU_NANI (NaNi)]

Hey!

You can try like this…

dtNew = dt.DefaultView.ToTable(True,"ColumnName")

Regards,
NaNi

[Gokul001 (Gokul Balaji)]

Hi @nikhil.patil

To get the Duplicate value Use this expression

(From p in DT.Select() where( From q in DT.Select() where q("ColumnName").Equals(p("ColumnName")) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

After that can you share the sample input and output here.

Regards
Gokul

[nikhil.patil]

how to convert text file to excel file in uipath program

[Gokul001 (Gokul Balaji)]

Don’t Create an Duplicate post or topic @nikhil.patil