Avoid excel which has missing sheet in Dynamic input tool

seito

I tried to pick up specific data from many excel which has specific name sheet. So I use directory tool and dynamic input tool. However there are some excels which doesn't have specific sheet so that Alteryx breaks.

Is there the way to avoid these excel towards dynamic input tool?

WF_sample.PNG

Felipe_Ribeir0

Hi @seito 

One way of doing this is using the dynamic input tool to get the sheet names of the files, filter the wanted sheet names and use the dynamic input again to open them. Take a look at the attached workflow.

Avoid excel which has missing sheet in Dynamic input tool.yxzp