Merge Datatable activity not working

Hi All,

I am currently using merge datatable activity to merge 3 different excel files with same number of columns and same column name but variable number of rows. But for some reason only last excel file data is getting added to the datatable.

I am using Read Range activity in a loop to read through all 3 excel files.

Can anyone please help me on this?

Regards,
Hitesh M. Jeswani

@HiteshJeswani101

You can try the below attached, this will give you 3 different files to 1 excel file

ExcelMergeAndFormat.zip (41.9 KB)

Mark as solution if this helps

Thanks

Hi @ksrinu070184,

Thanks for the quick reply. but I am not looking to create a new excel file. I want to dynamically loop through the files and create a datatable since I have many folders to iterate through and all of them contain multiple excel files. Creating a new excel file for each and every folder is not feasible for me.

Hope you understand the problem.

Regards,
Hitesh M. Jeswani

@HiteshJeswani101

Can you share your xaml folder with some samples, so that i can try

Thanks

Please find the xaml file attached below along with samples

Regards,
Hitesh M. Jeswani

Main.xaml (9.3 KB)Excel_Operations - 2.xlsx (8.3 KB) Excel_Operations -.xlsx (8.3 KB) Excel_Operations.xlsx (8.3 KB)

@HiteshJeswani101

Check Attached

Merge Tables.zip (20.5 KB)

Mark as solution if this helps

Thanks

Thanks a lot @ksrinu070184. The solution worked perfectly!

Regards,
Hitesh M. Jeswani

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.