Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello - I know this is a common issue and there are lot of posts on this topic. I have a similar issue but slight different. I tried my best from community posting but was not able to resolve it.
I want to import 2 specific sheets which have different schema from multiple excel files (all files are saved in one folder) union them and then through batch macro combine all outputs. I want to open both sheets at the same time in my Macro Workflow so in the Input Data Tool I specified the name "West" and "South". When I run this workflow stand alone I am not getting any error. But when I run Main Workflow which has a directory tool & Batch Macro Tool I am getting an error message "No sheet specified you must specify a sheet". I am confused why asking for specify a sheet when I already specified both sheets in Macro Workflow Input Data Tool.
I have attached both Main Workflow and Macro Workflow along with my two sample excel files. I would appreciate if some one help me in fixing this problem. Not sure which workflow need to be fixed. It is my understanding that I do not need to use dynamic inputs tool as I am using the batch macro. Thank you in advance and hope some experts will help me.
Muhammad Anwer
Note: I am using Alteryx version 2018.4
If you need any another explanation please let me know.
Solved! Go to Solution.
Hi @anwerm2
I tried out your macro it works fine for me.
Folder structure:
Data is the folder where i have all the files
When i run your app and set the path to this folder it works.
Referring to the location where files are saved.
Output:
Please check and let me know. Make sure your folder has the .xlsx files
I have attached the zip folder.
Hope this helps 🙂 feel free to reach out.
