HOW TO SELECT SPECIFIC SHEETS IN A WORKBOOK AND COMBINE THEM INTO ONE EXCEL FILE

Hi, I'm new to Alteryx and I would like to know how do I select specific sheets in a workbook and combine them into one excel file? For example I have a file with 6 sheets, 1st sheet was named SUMMARY then the next sheets were named DETAILS 1, DETAILS 2, DETAILS 3, DETAILS 4 and DETAILS 5. I need to combine DETAILS 1 to DETAILS 5 sheet into one excel file (excluding the SUMMARY sheet). How do I do that? Thanks heaps!

Input

Accepted answers

Hi @CathrinaJay

One thing you need to do prior importing the data's from all 5 sheets are , the Schema should be same.

i.e, the order of the columns in all 5 sheets should be same.

Or the data's will be merged but it will read in different column names matching to the first input sheet.

Many thanks

Shanker V

All comments

Hi @CathrinaJay

Take a look at the attached workflow

I am using the input tool to get the names of the sheets inside of the file

The filter tool to filter only the sheets that i want to read

And the dynamic input to union them all

Avoid excel which has missing sheet in Dynamic input tool.yxzp

Wow! I will definitely try this one! Thank you so much Felipe for the help! God bless!

KrishnaChithrathil

you can refer this if have less number of sheets.

taking each sheets and saving it to new excel.

SELECT SPECIFIC SHEETS IN A WORKBOOK.yxmd

Hi @CathrinaJay

I am glad it was useful . If you could select the answer as a solution, i would appreciate it.

Hi @CathrinaJay

One way of doing this.

Many thanks

Shanker V

Hi @CathrinaJay

Step 1:

Step 2:

Step 3:

Many thanks

Shanker V

Hi @CathrinaJay

One thing you need to do prior importing the data's from all 5 sheets are , the Schema should be same.

i.e, the order of the columns in all 5 sheets should be same.

Or the data's will be merged but it will read in different column names matching to the first input sheet.

Many thanks

Shanker V

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703