Read both as dt n merge n then sort the merged dt

Filter datatable activity will not sort

You have to use sort datatable activity

I have used sort data table activity but I want to do sorting for two columns

First hire date then followed by employee name

Ok I'll try this

In the first time, you have to do for one column and in the second time u have to do for other column

But in the second time, you have to input your previous sorted output table as a input

Or else you can use a linq query for both columns at a same time

Ok 👍🏻

I tried this but not good at it

What does this mean if we get error workbook doesn't exist.. actually I created workbook and give exact file name and file path..then also same error

Linq query for sorting,
From x in dt.asenumerable()
Orderby x.Field<string>(column name1),
x.field<string>(column name2) ascending
Select x;

share screenshot of the code

Why Learn Robotic Process Automation?  
According to a survey conducted by UiPath, RPA professionals are seeing tremendous career opportunities and believe that RPA industry has high potential for growth over the next five years.  
 
RPA technology delivers rapid ROI and requires minimal upfront spending compared to other enterprise technology. RPA reduces the time taken to complete the processes, with a very high accuracy and increases employee productivity. Due to these features, RPA is the fastest-growing enterprise software in the world.  
 
Software bots can work all the time – 24-hours a day for the complete year, at 100% capacity. If your process changes and the bots need to learn something new, you can either replace them with new bots or alter their programming.  
 
RPA online course and start learning with India's top instructors. We offer the best robotic process automation courses with current industry requirements . Batches will start soon.

Contact: 7829100498

Tried this but it is removing first sorting condition and applying only second sorting condition

See

Ok I'll try this

Dt_sort= (from x in dt.asenumerable() orderby x("column1"), x("column2")
Select x). copytodatatable

Try this as well