I am trying to open files from multiple folders with the same name and same schema using a macro to get sheet names then filtering out the required sheet name then putting a dynamic input to open them all.
Other tabs are opening fine through this method but just one tab is giving this error even though the schema is not different at all, I have actually copied one file across all folders as a test run.
Is there any way to resolve this issue?
Try to see if there is an additional file that Alteryx is trying to open that is not any of the test files, as if all the files were the same you will not get this error.
Check the list of all the files that goes into the Dynamic Input tool.
@saachitalwar use batch macro instead of dynamic input tool