Creating different sheets who salary greater than 50000

Employee_Data (1).xlsx (10.6 KB)
Hi ,
could anyone please help me how to create different sheets as per the Department column , Sort Salary Colum in ascending order and employees whose salary is less than 50000 add status as yes else keep the status as No.

By using linq query or using any activities

1 Like

Hey @Siva_prasad_meda

Please try with Filter DataTable activity.

Hope that helps

Thanks
#nK

@Siva_prasad_meda
have a look here:

How to Update Data Column Values of a Data Table | Community Blog

[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

about the salary filtering you can start to convert the column value into an int32 with CInt(YourColValue)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.