How to Separate Duplicate Data?

[Perawat]

Hi,
I want Separate duplicate data and put that information on another sheet.

Test.xlsx (9.4 KB)

Can you help me ?

Thanks.
Perawat

[Palaniyappan (Palaniyappan P)]

Hi

Welcome back to UiPath forum

Hope this thread will help you get the duplicate records which we write in another excel with write range activity

1. First use a excel application scope and pass the file path as input and get the output as datatable with read range activity named dt

2. Then use a assign activity and mention the below expression in left side and dt in right side

3. Then write dt to a excel with write range activity

How to get duplicate rows for specific column in a datatable

HI @Sunitha_Bist1, Duplicate records from the same data table (From p in dt.Select() where( From q in dt.Select() where string.Join(",",q.ItemArray).Equals(string.Join(",",p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable() Try this one If you want specific Column alone mention the column name (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() Regards, Arivu …

Cheers @Perawat

[prasath_S]

Hi @Perawat

Please try this,

1. Read the excel sheet data using read range (uncheck AddHeaders) in the datatable variable name dt.

2. Use write range activity and give sheet name as “output”, datatable as below,

(From dtRow in dt.asenumerable
Group dtRow by k = dtRow(0).tostring.trim into grp = Group
Where grp.count > 1
Select grp(0)).copytodatatable.defaultview.totable(false,dt.columns(0).columnname)

For the reference

How do I group by one column in the datatable and take the sum?

@jamnanin I will suggest you one more way try like this. Let us take your excel stored in a datatable dta First group the datatable based on ID by using below Query and assign it to dt1 dt1=(From p In dta.Select() Group p by ID=p.Item(“ID”).ToString Into Group Select Group(0)).ToArray.CopyToDataTable() Now take only two columns by using below query dt1=dt1.DefaultView.ToTable(False,“ID”,“Name”) Now Add one datacolumn to dt1 by using add datacolumn activity and give name Amount to that c…

Thanks

[Perawat]

Hi @prasath_S

How do I use the code?

[prasath_S]

@Perawat Paste the code in the datatable field in write range.

Make sure read range output variable name is dt

Thanks

[Perawat]

@prasath_S
I didn’t get the results I wanted.
I want to display duplicate data.

Thanks

[Perawat]

@Palaniyappan , Thank you so much for your help.

[Perawat]

@prasath_S , Thank you so much for your help.

[prasath_S]

@Perawat think i missed a condition there,my bad o updated my query hope it will work now.

Glad your issue is resolved.

Thanks