How to merge multiple tables of the same type into a single table

Learning Hub
, , ,
1

Hello everyone,

I have an excel file. There are tables in different rows with the same columns in each sheet of this excel.

My goal is to write the tables in all sheets one by one in a separate excel sheet.

How can i do that?

2

Create a master table containing the columns you have in your Excel workbook.

Use the Excel Application Scope to read the file, and then get the array of sheets. Iterate over that array, and read the range from each sheet using Read Range. Merge the table with the master table, and all of the results will be in one datatable.

Use Write Range to write the data to one sheet.

3

But with which activity i will merge these datatables?

@Anthony_Humphries
@Palaniyappan

4

You can use the Merge Datatable activity to do this.