Add Data tables

I have two excel workbooks with data and I want to combine the first column and sort it alphabetically. How would i go about combining the two datatables as well as sorting it?

Hi @UiUser,

You can use Merge Data Table to add those datatable values and then, use Sort data table by specifying column index and datatable to sort it.

here’s one sample workflow for your better understanding. —> test.xaml (8.8 KB)
image image
o/p —> image

Hi @UiUser

I think you can use Join Data Tables and Sort Data Table to implement your case.
Or you provide two sample table, that someone can make a example for you.