Hello!
I have 19 Excel files with with 2 to 5 useful sheets in them and each file has one "junk" sheet that I do not need imported into Alteryx. When I run the workflow, it goes through the files in order, 1 through 19, imported information in Sheet 1 and then goes back to file 1 and starts importing Sheet 2. When it gets to file 14 and tries to import Sheet 3, the workflow errors because file 14 does not have a Sheet 3. I am new to Alteryx within the last month so I have am not sure what tools would be best for this. I have an Input Data function with a Wildcard to get the sheet names and then a Dynamic Input tool to pull them all in.
I am seeing a lot of similar posts with macros being the solution but I am not sure how to modify these to help me out. I tried deleting the "junk" tabs from the source data and still ran into the same error. The best I can gather with my limited experience is that I need Alteryx to recognized not all files will have a Sheet 3, 4, or 5 and continue to import the data. As it stands now, it stops running when it hits the first file without a Sheet 3 so I end up importing 85% of the total population of data. If there is someway to build a workflow that ignore the "junk" sheets as well that would great.
Thanks for the help.
