Two different excel file merge into one data table

Help Studio
, ,
1

I have two different excel file in that i want to read this two different excel files and combine to one datatable UiPath studio Re framework

2

Hi @pallavi_patil2

Get 2 Excel application scope. Inside that add read range activity each for particular excel.

You will get output of read range in datatable format use that in merge data table activity you will get the combined datatable.

Hope this helps :slight_smile:

1 Like
3

Hi there,

You need to provide more details. Is the data in the two separate files the same structure? meaning the same columns?

Out of curiosity, what is the end goal for this use case?

4

@AJ_Ask Thanks For reply i will try

1 Like
5

For ref: https://youtu.be/KUekDejExpE?si=ss3qV06eUdtTng8X

1 Like
6

I am reading mail with given condition and then downloading files and then from a particular folder I need to read those files and save to one datatable

1 Like
7

@SenzoD please check this

8

ok,Thank you so much, I will refer this.

9

Got it.

If the goal is to merge the data into one file, you might as well just read file1 into a datatable using the read range activity, and then use the append range to copy the data into file2. this way you have copied data from file one into file two. (merged the data from two files into one)