How to merge multiple DataTable with same columns but in different order

Question

I have multiple excel sheet and the same column but are in different order. Now i want to merge all using uipath.

i used while loop but data are not appending with their respective column.

Kindly suggest how should i do?

Answer 1

You can use Merge Data Table activity.

Check this out https://forum.uipath.com/t/append-two-datatable-with-same-columns-but-in-different-order/13810

Comments

There is no solution in this. Same issue i am facing what the user giuse.devivo is facing

---

See if this tutorial can help!
https://docs.uipath.com/studiox/docs/tutorial-extracting-data-from-automated-emails-moving-it-to-a-desktop-application

---

@Linda no it is totally irrelevent. Anyone can give proper solution?

Answer 2

You can do one thing to arrange both datatable column in same order, you can get the column name of both the datatable in an array and sort it in asc or desc order and using the dataview method arrange the columns of both the datatable according to the reapective arrays