Duplicate rows adding in the output file

Help
, ,
1

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.

Thanks,
Bala.

2

you can use Remove Duplicate row activity

1 Like
3

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

4

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

5

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

6

upload a sample workflow!

7

before writing to excel you can use Remove Duplicate Rows

8

I have tried that too but not resolved

9

FilterWorkItemData.xaml (18.6 KB)

10

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

11

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

12

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

13

DuplicateValues.zip (11.5 KB)
Check this one
@Bala_Murugan_Kothand

14

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

15

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

16

FilterWorkItemData.xaml (18.4 KB)

17

Hi Pradeep,

Do you have solution for my issue?

Thanks,
Bala

18

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

19

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

20

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