How to join two datatables using LINQ in Uipath

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

Datatable1

Datatable2

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

LINQ Query

Following is the complete video of the tutorial

Github Repo : https://github.com/manojbatra071/UiPathSamples/tree/main/04%20-%20JoinTwoDatatables

Happy Automation