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!
Solved! Go to Solution.
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
Wow! I will definitely try this one! Thank you so much Felipe for the help! God bless!
you can refer this if have less number of sheets.
taking each sheets and saving it to new excel.
Hi @CathrinaJay
I am glad it was useful :). If you could select the answer as a solution, i would appreciate it.
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