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.
you can use Remove Duplicate row activity
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
@Bala_Murugan_Kothand
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?
Thanks,
Bala
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