Challenge in data combining.

[amy87leo_05]

Data set Sample Work book 1 - 5 sheet with different names few blank and few with data. Can anyone help me to prepare a WF as I have around 250+ such sheet.. Also I need sheet names in my final output.

[mceleavey]

Hi @amy87leo_05 ,

yes, we can help, but not without any data examples, examples of the challenges, where you're stuck and what you would like to see.

If you could provide this, we'll be able to help.

M.

[alexnajm]

Agreed with @mceleavey - show us what's going on! 

If you need a place to start, there are a lot of example on the Community for how to read in sheet names from multiple files (How To: Import Multiple Excel Sheets or a Specific Excel Range into a Workflow), then read in the data one by one with a batch macro (The Ultimate Input Data Flowchart)

[amy87leo_05]

Thank You for Response M.! my dataset - work sheet 1 have 5-6 sheets having unique names(Dates). Goal - Combined dataset by all dates and extract summary , count, aveg etc. There are 250+ worksheet with 5-7 sheets in each., screen shot or sample uploading is restricted by my employer.

[alexnajm]

Then the links should help! Start building and let us know what errors you come across 👍

[Qiu]

@amy87leo_05 
This post discusses the simalar issue. You can also check this out.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Combine-multiple-sheets-from-o...