I just started my Uipath journey. As for now, I try to do a lot exercise to
strengthen my skills.
As I’m on my excel exercise, I try to find the top value in excel. For example, I try to find top 3 best students in excel and display it to message box or display it to new excel file. But I dont know how to find the top 3. Do I need to use For Each Row activity? I try to refer past query n Youtube but it’s negative.
@Ahmad_Albab if you have a condition like marks<35 then use filter datatable activity. Write your column names in filter data table activity then store it in output datatable and see your output in message box
@Ahmad_Albab Yes you take read range activity mention the output of datatable in read range and take the activity from “Datatable” Under “Filterdatatable” and mention the datatable name(Read range output) in filter datatable Activity
@aman_sheik i already try. and i get it. thank you. but the only problem is i cannot sorting it ascending. it’s just by default. i use this to assign activity.
(From row in dtin. Select Order by row(“Salary”) select row).CopyToDatatable()