How to Separate Duplicate Data?

[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