Fetch excel data from datatable, compare and get the value of different column in the row

[Gopalakrishnan_K]

Hi,
I do have a table for example:
Name Age
Gopal 40
Roshan 50
I’m having an input string Roshan. I need to compare a string with the names in the table. If I found a match, I need to return the age of the corresponding person. How can I do it without looping. I’m trying to do it without looping because the table length is long .

[prasath_S]

Hi @Gopalakrishnan_K

Please try lookup datatable activity,

Lookup Data Table

Thanks

[Marius_Puscasu]

Hello @Gopalakrishnan_K ,

Please give a try and use the Filter Data Table activity (https://docs.uipath.com/activities/docs/filter-data-table )
In your case, you could try to filter by the input string Roshan, and extract the age number from the result

Hope it helps
Best regards,
Marius

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

If you don’t want any looping logic.

Use vlookup formula to get the data from different sheet or workbook by using match. In our case name is the comman for both the sheets.

Use write cell formula to insert the vlookup formula to cell and use auto fill range activity to fill the vlookup formula to all the cell in the age column.

By using the above logic we can get the age for all the names in the first column. Thanks.