How to delete dublicate values in excel. based on 2 different columns dats

[MitheshBolla (Mithesh Reddy Bolla)]

How to delete dublicate values in excel. based on 2 different columns data.

[ppr (Peter Preuss)]

we can use a group by for detecting the duplicates

VB:

dtResult =

(From d in dtData.AsEnumerable
Group d by k1=d("Case Number").toString.Trim, k2=d("Receipt Number").toString.Trim into grp = Group
Where grp.Count = 1
From g in grp
Select r = g).CopyToDataTable()

Also have a look here where also a Non-LINQ approach is described:

[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…

[MitheshBolla (Mithesh Reddy Bolla)]

bro if u dont mind, can i have it in c#

[ppr (Peter Preuss)]

did you get work on the other LINQ statement or are the assign statements still blocked? If there are still blocked we would recommend implementing the described non-LINQ approach. Maybe also good

C# would a like as:

dtData.AsEnumerable()
.GroupBy( d => new { col1 = d["Case Number"].ToString().Trim(), col2 = d["Receipt Number"].ToString().Trim()  } )
.Where(g => g.Count() == 1)
.SelectMany(x => x)
.CopyToDataTable()

[balupad14 (Balamurugan)]

HI @MitheshBolla ,

Try this one!

Remove duplicates in excel while its in lowercase or uppercase

Hello @uday_kumar, Here is a custom activity for remove duplicate. Regards Balamurugan.S

UiPath Excel Remove duplicate | Multiple columns (remove duplicates)

Regards
Balamurugan.S

[MitheshBolla (Mithesh Reddy Bolla)]

as i am working in c# its trowing error.

[ppr (Peter Preuss)]

as mentioned we would recommend focusing on the infrastructure that C# and LINQ will be in general reliable work. As a workaround, you can implement it with the Non-LINQ approach

[MitheshBolla (Mithesh Reddy Bolla)]

should i import any packages?

[ppr (Peter Preuss)]

have a check on updated LINQ from above

[MitheshBolla (Mithesh Reddy Bolla)]

@ppr

dtData.AsEnumerable()
.GroupBy( d => new { col1 = d["Case Number"].ToString().Trim(), col2 = d["Receipt Number"].ToString().Trim()  } )
.Where(g => g.Count() == 1)
.SelectMany(x => x)
.CopyToDataTable()

All errors gone bro, but one is remaining

[ppr (Peter Preuss)]

Perfect, looks like a dot net infrasctucture issue.

Just have a check on Forum search for similar issue. Otherwise share the details like:

• uiPath version
• targetframework from project (depending on versions)
• used UiPath.System.Activities version

Maybe someone can replicate or UiPath will get looped into the discussion

[MitheshBolla (Mithesh Reddy Bolla)]

uipath version = 2021.10.5

uipath.system.activities = 22.4.1 (its suggesting me to update to latest )

[MitheshBolla (Mithesh Reddy Bolla)]

@supermanPunch , can you help with this c# code, failing at one step, while trying to delete dublicate values in datatable of two columns

[supermanPunch (Arpan)]

@ppr

Maybe someone can replicate

Hi @MitheshBolla ,

As Peter mentioned, I do think it is a kind of bug that has been found when using c# as the Language.

I did try with the other method of grouping as well, where it ended up having the same error.

It needs to be directed to the UiPath Team for the final conclusion.

But before that do try with the Latest Packages/Dependencies. To Check if it was corrected in the later releases.

Note: This happens when trying to group with more than one Column. No Error found when grouping with One Column.

[ppr (Peter Preuss)]

with the valuable input from Arpan maybe you can do a trick like:

dtData.AsEnumerable()
.GroupBy( d => d["Case Number"].ToString().Trim() + "_" + d["Receipt Number"].ToString().Trim() )
.Where(g => g.Count() == 1)
.SelectMany(x => x)
.CopyToDataTable()

[MitheshBolla (Mithesh Reddy Bolla)]

@ppr

dtData.AsEnumerable()
.GroupBy( d => d["Case Number"].ToString().Trim() & "_" & col2 = d["Receipt Number"].ToString().Trim() )
.Where(g => g.Count() == 1)
.SelectMany(x => x)
.CopyToDataTable()

still error,

bro can u give dublicate rows delete when there are dublicates in Receipt number column?

that is enough . with one columns its not issue right.

[ppr (Peter Preuss)]

sorry had a type and did correct the statement

[MitheshBolla (Mithesh Reddy Bolla)]

@ppr

dtData.AsEnumerable()
.GroupBy( d => d["Case Number"].ToString().Trim() & "_" & d["Receipt Number"].ToString().Trim() )
.Where(g => g.Count() == 1)
.SelectMany(x => x)
.CopyToDataTable()

Still operator issue only bro,

[ppr (Peter Preuss)]

used + for concatenation it was accepted by compiler. check updated statement from above

[MitheshBolla (Mithesh Reddy Bolla)]

casenumber clolumn and receipt number column,

if the both column values are present in excel then its dublicate. so i want to delete one row .

Hilighted yellow are dublicates