<ul>
<li>
Generate an output table to find employees who have the highest salary in each of the department
Employees with the highest salary appearing first should be returned
</li>
<li>
Employee Sheet
<img src="/images/EmployeeSheet.jpg" alt="alt text" title="Employee Input Format">
</li>
<li>
Department Sheet
<img src="/images/DepartmentSheet.jpg" alt="alt text" title="Department Input Format">
</li>
<li>
Required Output
<img src="/images/RequiredDatatableOutput.jpg" alt="alt text" title="Datatable Output Format">
</li>
<li>
Solution:
</li>
</ul>
One of the approach to solve this in UiPath is to add one column manually in the Employee Sheet "departmentname" which will save all the appropriate name according to the "departmentid"
Above will achieved by using "invoke code" activity with logic of mapping the "departmentid" to "departmentname"
This activity will have argument of datatable type with direction set to "in/out" incase of reusing the same datatable variable.
Then use "DefaultView" method to arrange the column in the required format and use the linq query to get the required output.
<a href="https://github.com/SachinHatikankar100/UiPathPractice">Refer the working solution here </a>

Sachin Hatikankan

UiPath Datatable Practical Interview Question