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, 2020 in RPA by Tej
 • 150 points • 1,795 views
First, find the column index the continue with your process with column indexes.
commented Sep 29, 2020 by Sunny
It is not solution.
commented Sep 30, 2020 by Tej
 • 150 points

Hello @tej

Have u tried sunny's solution?

commented Sep 30, 2020 by Niroj
 • 82,840 points

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

0 votes
1 answer

How to get single value from multiple pages of pdf for ex. i want to extract Invoice Amount due from multiple page of pdf and all the pages are in same only amount is different. please help me out

You can use anchor base in that ...READ MORE

answered Oct 16, 2019 in RPA by Venkat
 • 2,361 views
+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, 2020 in RPA by Sirajul
 • 59,230 points • 6,409 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
 • 14,795 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,020 points • 4,369 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
 • 58,020 points • 1,707 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 • 2,299 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
 • 28,140 points • 2,853 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
 • 28,140 points • 5,873 views
0 votes
1 answer

I want to read Excel having two columns key & value if key exists in want to display value. How to do this?

You must probably use the dictionary in ...READ MORE

answered Oct 14, 2020 in RPA by Gaurav Malik
 • 727 views
0 votes
1 answer

I want to filter specific mail and read the mail but in this process I am unable to click the mail in first position, rather than it is clicking in other position. How to resolve this?

You can use the search feature and ...READ MORE

answered Nov 3, 2020 in RPA by Enigma
 • 692 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.