Hello,
Have some Alteryx experience, but still an acolyte.
Much to my chagrin I am struggling with the combination of the "directory tool" and "dynamic input". Searched forums. Learned how to import multiple files if in same directory (learned that), but I am trying to implement an import for hundreds of Excel files located in multiple folders.
Overall actions so far:
Directory:
Specified a parent folder
(Excel files of either xlsx or xlsm are present), Thus can not use wildcard for only one file type.
Dynamic Input
Select a file in one of the folders and selected the "sales" sheet.
Browse:
Added Browse to end workflow
Getting an error.
Can someone help point out where I am screwing up?
Thought this tool combo would be easier. If I figure out my error, then I can carry over into my functional model.
Thank you for any assistance.
Kevin
