Match Excel cells to get information from another

[Shikhar_Tandon]

Hi @standbones,

Welcome to the community.

You can use Join function for this. UiPath has a join activity you can refer that or a LINQ query can be written for joining the two datatables and storing the result you want into a third one.

You can refer below post.

How to left join two tables using Linq Query with all data in left table? Please Help

How to left join two tables using Linq Query with all data in left table? Please Help I need to left join two datatables “DT1” & “DT2” on Column “ID” and the result to be stored in FinalDT. [image] Query Used: (From a In DT1 Join b In DT2 On a(“ID”).ToString Equals b(“ID”).ToString Select FinalDT.LoadDataRow (New Object() { a.Field(Of String)(“ID”), a.Field(Of String)(“Name”), a.Field(Of String)(“Designation”) b.Field(Of String)(“Grade”) },False)).CopyToDataTable() I need to solve th…

Thanks