Hi
I have attached an excel along this. Find and remove duplicates along the row. Expected outcome I have mentioned in the attached excel. Kindly help with this scenarioDoubt.xlsx (9.6 KB)
1 Like
Fine
Hope the steps will help you solve this issue
Use Excel application scope and pass the file path as input
— use read range activity and get the output with a variable of type datatable named outdt
— use remove duplicate rows activity and pass the input as datatable obtained above and the output would be a datatable without duplicates
For more info on this
Cheers @Newton_Rich_SV
1 Like
As i can see to your excel file the value of column B is jumbled
i assumed it was just only an example…
you might use this as a reference.
Second scenario: If you can full the data in excel file and make it as datatable and do groupby with the column B(“IF the excel file has a header”)
you might use this as a reference.
cheers 
Happy learning
2 Likes
I have tried this method. But.it was not working for me. Kindly help with the same to get the expected output
1 Like
Re move duplicate rows should actually work hmmm fine
Kindly Try with this either
—hope you have read the excel with read range activity and output obtained as datatable named outdt
— so use a assign activity like this
Outdt = outdt.DefaultView.ToTable(True,”Columnname1”,”columnnme2”,”columnname3”)
Where mention your table columnname for each column and you will be getting the number of columns mentioned. So mention the one you need.
Hope this would help you
Cheers @Newton_Rich_SV
HI @Palaniyappan
This above code of yours works, but its writing only particular column value in new sheet.
A_Learner
vrdabberu
theidioms
matt.theisen