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