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?

[Felipe_Ribeir0 · Accepted solution]

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.

[seito]

 It works! I didn't know how <List of Sheet Names> works. Thank you so much!

[Felipe_Ribeir0]

@seito I am glad it worked for you! Please accept my answer as a solution!

Thanks!