Dynamic Input but Only Certain Excel Sheets

[tyler_schmidt]

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.

[AkimasaKajitani · Accepted solution]

If you use the "Import only the list of sheet names" option at Input Data Tool, you can filter the junk sheet by file name or sheet name.

Do the sheets have different schema?

I think the following workflow will help you achieve your requirements.

I attached the sample workflow.

But I don't know your workflow, so that workflow may not archive your requirements.

If you can share the workflow, I think that provide the solution faster(Screen shot is OK).

[tyler_schmidt]

Thank you for the help! I was able to teach myself how to use your solution to solve my issue.