Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Dynamic Input (22) The file "" has a different schema than the 1st file in the set.

saachitalwar
8 - Asteroid

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?

2 REPLIES 2
OTrieger
13 - Pulsar

@saachitalwar 

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.

binuacs
21 - Polaris

@saachitalwar use batch macro instead of dynamic input tool

image.png

Labels
Top Solution Authors