I do have a table for example:
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 .
Please try lookup datatable activity,
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
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.