Get values by comparing the Name from 2 diffrent tables and write in the value in 2nd table

[ManjunathReddy (P Manjunatha)]

Table 1

Table 2

Thanks in advance

[ppr (Peter Preuss)]

Listing a few options

• Join DataTable Activity and processing the JoinResult
• LINQ

also have a look here:

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

Maybe you can tell us if you are interessted on a inner or left join

[ManjunathReddy (P Manjunatha)]

How about lookup data table?

[lrtetala (Lakshman Reddy)]

Hi @ManjunathReddy

You can try with Vlookup

BlankProcess15.zip (168.0 KB)

Hope this helps!!

[sanjay3 (Sanjay)]

Hi @ManjunathReddy

Read Range ‘Sheet1’ → Output to dtTable1
Read Range ‘Sheet2’ → Output to dtTable2

Assign currentName = row(“Name”).ToString
Lookup DataRow in dtTable1:
Assign matchingRow (type: DataRow) = dtTable1.AsEnumerable().Where(Function(r) r(“Name”).ToString.Equals(currentName)).FirstOrDefault()

If Not matchingRow Is Nothing Then
Assign row(“Role”) = matchingRow(“Role”).ToString
Assign row(“Country”) = matchingRow(“Country”).ToString
Assign row(“Gender”) = matchingRow(“Gender”).ToString

Write Range ‘Sheet2’ with dtTable2 (make sure ‘AddHeaders’ is checked if you want to include the column names)