Is it possible? Datatable matching duplicates using linq

Help Studio
, ,
1

image
image894×348 6.49 KB

is it possible to have this result using linq on comparing 2 datatables? It’s easy using for loops but i want to do it via linq. TIA!

2

Hey!

Try this

Assign NewDt = Dt.DefaultView.ToTable(True)

This will remove the duplicates in entire table

Assign NewDt = Dt.DefaultView.ToTable(True,"Col1","Col2")

The above expression will remove the duplicates in particular column

You can use the first expression to remove the duplicates in entire table

Regards,
NaNi

3

Hi,

Can you try the following sample?

image
image679×635 18.9 KB 

dtResult = dt1.AsEnumerable.GroupBy(Function(r) r("ID").ToString).SelectMany(Function(g) g.Select(Function(r1,i) dtResult.LoadDataRow({r1("ID"),r1("Name"),r1("LastName"), if(dt2.AsEnumerable.Where(Function(r2) r2("ID").ToString=g.key).Count>i , dt2.AsEnumerable.Where(Function(r2) r2("ID").ToString=g.key)(i).item("Age").ToString,"N/A")},false))).CopyToDataTable

Sample20220726-4.zip (2.9 KB)

Regards,

4

Thank you for this it works perfectly!

5

Hello, I’m having a hard time implementing your code to my correct columns can you help me with this?

image
image1804×430 46.4 KB

6

Hi,

Can you share your workbook as a file?

Regards,

8

dt1
REVERSAL_INSTAPAY_SENDING_MC.xlsx (18.7 KB)

dt2
02132022_INSTAPAY_SENDING_MC.xlsx (19.0 KB)

thank you so much!

dt_result

image
image1243×122 6.55 KB

9

Hi,

Which column should we add or update from dt2 to dt1?
Do you mean if there is same number on TransID Column in dt2, update remark column to “PREV-RVSL”?

Regards,

10

Yep if there are matched change remarks to PREV-RVSL and if not match just put N/A

same logic as your first solution

11

this might help

dt1 are basically the result just need to update remarks if there are matched = PREV-RVLS and no match = N/A with duplicate handling as the first one

image
image1767×391 48.3 KB

12

Hi,

How about the following?

dt1.AsEnumerable.GroupBy(Function(r) r("Details.").ToString).SelectMany(Function(g) g.Select(Function(r1,i) dt1.Clone.LoadDataRow(r1.ItemArray.Take(dt1.ColumnCount-1).Concat({if(dt2.AsEnumerable.Where(Function(r2) r2("Trans ID").ToString=g.key).Count>i , "PREV-RVSL","N/A")}).ToArray(),false))).CopyToDataTable

Sample20220726-4v2.zip (30.8 KB)

Regards,

13

Okay. let me try this giving you my feedback soon tnx!

14

It works thank you so much!