Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello Alteryx Fam -
I am trying to connect to a folder with multiple excel files. All with the same columns headers, but different sheet names.
There are 9 files in the folder all with headers of the snippet attached. I would like to bring in this data and append it all in one place
@rterry One way of doing this is with the batch macro. Attaching a sample workflow for your reference
1. The first batch macro will read all the sheet names from the given folders
2. The second batch macro then will combine all the sheets data
@rterry below is the configuration for the directory tool, and you are correct the second tool is the batch macro which pulls all the sheet names from the given excel files with the full path name
Are you familiar with the batch macro?
@rterry if the sheets in the files are all of the same schema, then you can use a dynamic input tool instead of @binuacs's batch macros.
The first dynamic input reads in the sheets within all excels
We then create a new fullpath by replacing the <List of Sheet Names> with the actual sheet names
And then we can read in all the sheets from all the excels using the second Dynamic Input
This approach works when the schemas of the sheets and the files are all identical, otherwise you'll need @binuacs batch macro approach.
Hope that helps,
Ollie
