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

+1 vote
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?
Sep 24, 2020 in RPA by Tej
• 150 points
1,227 views

1 answer to this question.

0 votes
answered Sep 25, 2020 by Sirajul
• 59,070 points

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

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

Related Questions In RPA

0 votes
0 answers

How to merge multiple excel column value in one excel? The column name are same but are in different order.

How to merge multiple excel column value ...READ MORE

Sep 28, 2020 in RPA by Tej
• 150 points
591 views
0 votes
0 answers

How can I extract data from multiple different PDFs from same folder using config file in uipath ??

How can I extract data from multiple ...READ MORE

Nov 4, 2020 in RPA by anonymous
• 19,610 points
167 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

use a wildcard in selector. make sure that ...READ MORE

answered May 21, 2018 in RPA by wrecker
• 3,110 points
2,241 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

Just use a wildcard in selector. Given ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,110 points
551 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
8,518 views
0 votes
1 answer

How to select an item in UiPath that starts with a string?

Just use a wildcard in selector. Given ...READ MORE

answered Jun 29, 2018 in RPA by wrecker
• 3,110 points
771 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,120 points
2,818 views
0 votes
2 answers

Excel contains complete data with , separator how to split in blue prism

Import the bundled Utility - Strings Business ...READ MORE

answered Jul 2, 2020 in RPA by Kim
1,030 views
+1 vote
1 answer

Want to implement RPA in my organization, dont know how to start and how to calculate ROI for it?

Hey @Pritam, It's really a good thing ...READ MORE

answered Mar 2, 2020 in RPA by Sirajul
• 59,070 points
206 views