How to identify duplicate rows based on 3 different columns?

[Tana20]

Hi All,

I want to retrieve duplicates based on the columns “Supplier”, “Invoice”, and “Code” in workbook Test.xlsm, remove them from Sheet1, and paste them to Sheet2.

I already know how to remove duplicate rows within a DT using the activity, but that is not the goal.

Example
Input:

Expected output:

This is what I have so far using Linq, but I didn’t figure out how to group by 3 columns, and I don’t know if there is another way to accomplish this task,

FindDuplicates.zip (81.1 KB)

Currently, it can group by 2 columns but not for 3:

Unfortunately, I cannot use non-official activities

Regards.

[prasath17 (Guru)]

@Tana20 - Please check this

Find and remove duplicates in two datatables based on values of two columns

Hello, i am trying to delete duplicate datarows from two different tables based on two columns. [example 11] I have two data tables that look like the sample sheet above, where I want to delete the duplicates found based on both column C and column D. Is there a linq query that i can use to do this? Thanks in advance!

[Tana20]

@prasath17 Thanks, it works!

[park363 (UncleDev)]

This way works well too!
try it.

dt.AsEnumerable()
	.GroupBy(r => (r["Supplier"],r["Code"],r["Invoce"]), r=> r)
	.Where(r => r.Count() == 1)
	.Select(r => r.ToArray()[0])
	//.SelectMany(r => r)
	.CopyToDataTable();

[prasath17 (Guru)]

@park363 - Have you tried your solution? Lamba expression doesn’t work in Uipath, we have to change it to Function(x) x something like this…

Do lamda expressions work in UIPath?

Hello, I’ve noticed that when using an expression with a lambda expression, UIPath always prompts an error with the following message “Expression expected”.

[park363 (UncleDev)]

upper code is c#.
as your comment, vb uses ‘Function(x) x’ for lambda.