Duplicate rows adding in the output file

Hi All,

After executing the process successfully I have filtering the data and uploading to the excel sheet.

I’m facing the issue that the duplicate row is adding to the excel file always.

How to delete that duplicate row from the output excel file.


you can use Remove Duplicate row activity

1 Like

But this is Data table related activity,right. Do you have any example for this one.

yes it is!
you are working with datatable activity only right??

No, After building the Data table then writing to excel sheet.
So I use excel application scope.

upload a sample workflow!

before writing to excel you can use Remove Duplicate Rows

I have tried that too but not resolved

FilterWorkItemData.xaml (18.6 KB)

You are using delete row inside for each row activity which wont work
once evrything is done
before writing it to excel
use Remove Duplicate Row activity
and Write it

Do one thing use the Write Range at the end with Remove Duplicate rows,
Do not use with in the loop, any how operation is in Datatable so use at the end

or use this dataTable new_dt =
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“columnWithDuplicateValues”)).Select(Function(g) g.First).CopyToDataTable

DuplicateValues.zip (11.5 KB)
Check this one

I have tried this method but now also its adding the duplicate row

I have tried this method also but now also its adding the duplicate row in the output excel file

FilterWorkItemData.xaml (18.4 KB)

Hi Pradeep,

Do you have solution for my issue?


can you give me sample excel ?
to delete duplicate rows?

WorkItemData.xlsx (12.0 KB)
From the above excel I’m filtering the data and put in to below excel sheet

Results.xlsx (8.0 KB) - Its retrieving correctly but duplicate row added for one WID.

Check it once

it’s Not Duplicate @Bala_Murugan_Kothand
eveything is different in WID column
Description column is having same data