Hi all, this is my first post in this wonderful UIPath community.
I’m new in UIPath and I’m starting to learn to work with it.
I’m trying to simulate a sequence that I developed in Python and I want to try to do in UIPath.
I have 2 excel files (excel1 with 10000 rows, excel2 with 5000 rows) and I need to create a third excel that will be the concatenation of that two files (excel 3 with 15000 rows).
Excel1 and Excel2 have the same column but in different order, for example in Excel1 I have the column “ID” as third column, in Excel2 the column “ID” is in the first column.
I created an “Excel application scope” for each excel file, where I created a “Read range” activity where I specified an output variable. At least, I created another “Excel application scope” where i create an “Write range” activity where I specified the name of a new file and the output variable of first excel, and than I created an “Appen range” activity with the other variable in order to append data of second excel. The problem is that the result is not correct because the column are not in order… Under the column “ID” of the first excel, I have another column of the second excel.
Can someone suggest me how to solve it?
Thank you very much.