Remove Duplicate rows based on primary key

[Deeipauk (Deeipauk RS)]

Hi Team,

Below is my input excel

From this, I want to filter out unique names and enter in the next sheet like this

I was trying to do this programmatically but it is getting complicated, please suggest is there any easy way to do this?

[pattyricarte (Patty Boy)]

Hi @Deeipauk

Did you try to use this activities.

also you can use the group by function in dattable to get your desire output.

cheers

Happy learning

[GBK]

@Deeipauk - you can try below -

• use Read Range activity to read the data from Excel file and will give you output as DataTable and like ‘dtEmpDetails’.

• Create a new datatable variable like dtFilterdEmp

• use assign activity and write below code to filter the data

dtFilterdEmp =  dtEmpDetails.DefaultView.ToTable(true, “Name”)
**or** 
dtFilterdEmp = dtEmpDetails.Asenumerable().Gropyby(Function(a) a.Field(of string)(“Name”)).Select(Function(b) b.First()).CopyToDatatable()

• use Write Range activity and pass that dtFilterdEmp to write into new excel file.

[Deeipauk (Deeipauk RS)]

Hey Thanks for your response,

Duplicate row works when all columns are same but for me based on Name I need to filter other columns are already different, so this is not working

[Deeipauk (Deeipauk RS)]

Hey thanks for your response, this is quite simple and is working fine