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?