Consolidation of multiple sheet from ONE workbook

Hi All-

I have been trying consol all sheet from one workbook , gone through the many example but couldn't get through .

Eg. I have one workbook called it Book1.xlsx. It has 50 sheet sheet1, Sheet2 ..... Sheet50 and all the headers are same across all the sheet.I want to console all sheet into one sheet.

Any suggestion would be appreciated.

Thanks.

Mukesh Y

Dynamic Processing

Accepted answers

ChrisTX

The article list listed above, The Ultimate Input Data Flowchart, will help with situations when a sheet has different headers or columns. You'll need a batch macro.

Chris

All comments

ChrisTX

In your Input Data tool, choose Table or Query = <List of Sheet Names>

Then use a Dynamic Query tool. Point the Template to your input file. When setting up the Template, you can use the field for "Output File Name as Field", if you want to include Sheet names in the output. See screenshot below.

Annotation 2020-07-04 075054.png

The post is frequently helpful:

The Ultimate Input Data Flowchart

Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Chris

Mukeshy12390

thanks for the quick reply.

it works perfectly as I requested,

one question If I may, if headers are not common every sheet has 1 or 2 extra header which supposed to be part of output.

Is there any way we can do consolidation on the basis of header Name.

ChrisTX

The article list listed above, The Ultimate Input Data Flowchart, will help with situations when a sheet has different headers or columns. You'll need a batch macro.

Chris

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703