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

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

i am stuck at one point. i am a new uipath learner and i want to merge multiple excel DataTable with same column name but are in different order. Like suppose if name column are in first place in first excel but in second excel it is on third place. So in this situation how we will merge all data at correct position.
Sep 28 in RPA by Tej
• 150 points
101 views
First, find the column index the continue with your process with column indexes.
It is not solution.

Hello @tej

Have u tried sunny's solution?

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In RPA

+1 vote
1 answer

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

You can use Merge Data Table activity. ...READ MORE

answered Sep 25 in RPA by Sirajul
• 58,130 points
106 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
6,783 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
• 57,700 points
2,538 views
0 votes
1 answer

What are the steps to command RPA Bot to Iterate name in dropdown using workfusion. (RPA)

For me iterating lists works fine.  Use a 'foreach ...READ MORE

answered Nov 2, 2018 in RPA by Priyaj
• 57,700 points
853 views
0 votes
0 answers

HOW to extract a column data and save it in the new sheet using UIPATH

Sep 12, 2019 in RPA by anonymous
• 120 points
724 views
0 votes
1 answer

How to read data from a excel, based on that data, check in the corresponding checkbox in browser appln? Uipath

Hi, to achieve this, you can perform ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 27,930 points
845 views
0 votes
1 answer

How to open an excel file with a dynamic file name such that the file name is FXTB-(date today) using UI Path.

Hey Alza, I am trying to understand ...READ MORE

answered Oct 14, 2019 in RPA by Abha
• 27,930 points
1,473 views
0 votes
1 answer
0 votes
1 answer

Writing multiple column in excel UiPath

You can read the entire Excel sheet ...READ MORE

answered May 9, 2018 in RPA by wrecker
• 3,110 points
2,245 views