How to join two datatables using LINQ inUipath

Problem statement : we need to join two datatables based on a common column values and saves it to a new database.

These are the datatables


Here, the department column in present in both the datatables and we need to apply join condition on that column values

Drag the assign activity to the workflow and write the following code

Here is the video

Youtube: Join Datatable Using Linq in Uipath - YouTube

Medium: How to join two datatables using LINQ in Uipath - Manoj Batra - Medium

Code Repo: UiPathSamples/04 - JoinTwoDatatables at main · manojbatra071/UiPathSamples · GitHub

Happy Automation