Eliminating duplicate rows by comparing values in different cells

[parimala.prata (pari)]

Hi all,

as part of my workflow, I merged 4 different datatables into one single datatable. There could be duplicate rows in the merged datatable. Sample screenshot is below.
The order number will be populated in one and not the other between the duplicated rows. The client dispute id, invoice number and disputed amount are the common values between each set of duplicated rows.
my requirement is if client dispute id, invoice number and dispute amount are the same between any two rows, the one that doesn’t have the order number must be deleted.
I am not sure how to go about this scenario. can anyone suggest ways to go about doing this.

Thank you,
pari

[SenzoD (Senzo Dlomo)]

@parimala.prata, hey man, is there a reason why you did not compare the data tables before you merge them together?

[parimala.prata (pari)]

The data is not redundant within the data tables themselves. When i combine all datatables together, the duplicity occurs.

[parimala.prata (pari)]

Also, i was thinking if there is a way to identify the duplicates under the invoice number column and remove that row. this could also work for my scenario.

[ppr (Peter Preuss)]

@parimala.prata
Have a Look Here
Linq query to identify duplicates and delete both entries - #3 by ppr

And Here

Could you help me insert a new column in an excel file, enhance it and eliminate duplicates from the table?Thanks

@vittoria I have for time reasons implemented with a smaller set of sample data, but it can be extended easy to more columns configure in the default values the cols for concatenation and concat colname [grafik] data in: [grafik] data Concated with configured columnname: [grafik] Duplicates [grafik] Non Duplicates [grafik] with filter datatable and set to the remove column colname = ConCatCol you can easy remove the concat column Find starter Help here: DupNonDup_ByConfColList_Con…

[parimala.prata (pari)]

hi,
I tried the third scenario where it will keep all rows and remove the first duplicate. Getting an error. Do i have to install any packages?

thank you,
pari

[ppr (Peter Preuss)]

Nö additional package IS needed. Linq should be in the imporzed namespace. But in such a Case Always refer to running Demo.
From d in dt.asenunerable is needed

[parimala.prata (pari)]

it was my fault. didn’t include a opening bracket. this time i am getting another error.

[ppr (Peter Preuss)]

@parimala.prata
As in the running Demo the used variable is of datatype Datatable IT has the Method asenumerable

The Same IS required in your Implementation. In Case of there is an issue with Import of the datasetextensions into the namespaces have a Look Here

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

[parimala.prata (pari)]

Hello ppr,

thank you for your assistance. I had to add the assembly reference to fix the issue. The initial piece of code you provided worked like a charm.

This community is awesome…Lots of experts actively engaging on the forum and helping people resolve their issues. Also the trove of knowledge that is shared through the forms is awesome. Extremely helpful.

Thank You,
pari