Keep duplicating rows

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

1 Like