I want to copy duplicate data only which ID,R1,R2 column has duplicate value

[supermanPunch (Arpan)]

Hi @Gaurav_Gore ,

We could perform Grouping of the rows based on the 4 columns as per the condition mentioned, and then we can capture the rows whose grouped Count is greater than 1 (2 or more), which would capture your required result.

Try the below :

1. Assuming, Excel sheet is already read as a Datatable, say DT using Read Range activity.

2. Next, we can create a Output Datatable by making a Clone of the Input DT like below :

OutputDT = DT.Clone

3. Next, we can perform the Groupby and Filter only the Row Groups having count more than 1 (Duplicates).

OutputDT = DT.AsEnumerable.GroupBy(Function(x)New With{key .a=x("ID").ToString,key .c=x("R1"),key .d=x("R2")}).Where(Function(x)x.Count>1).SelectMany(Function(x)x).CopyToDatatable

4. Next, you could write the OutputDT to an Excel sheet using Write Range activity.

Implementation :

For more on Linq Groupings :

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

Also, If there are no rows as Duplicates, you would need to handle it using the below method :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…