Keep duplicating rows

[E.T.S]

Hello,

I have two data tables. I would like to use a LINQ statement (or any method) comparing column 1 from two data tables - if they are matching I would like to keep the row and copy to a data table.

Please advise cheers

[Ajay_Mishra (Ajay Mahendra Mishra)]

Hey @E.T.S

Here is the solution:
Just using simple Join,

(
From main In dt_Table1
Join row In dt_Table2
On main("1stTableColumnName").ToString.Trim Equals row("2ndTableColumnName").ToString.Trim
Select main
	).CopytoDatatable

Screenshot for your reference:

Happy Automation!

Regards,
Ajay Mishra

[E.T.S]

That’s awesome works like a charm thank you!