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

[CathrinaJay]

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!

[Felipe_Ribeir0]

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

[CathrinaJay]

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

[KrishnaChithrathil]

@CathrinaJay 

you can refer this if have less number of sheets. 

taking each sheets and saving it to new excel. 

[Felipe_Ribeir0]

Hi @CathrinaJay 

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

[ShankerV]

Hi @CathrinaJay 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @CathrinaJay 

Step 1: 

Step 2:

Step 3:

Many thanks

Shanker V

[ShankerV · Accepted solution]

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