topic Dynamic input in Alteryx Designer Desktop Discussions

Dynamic input

Andrej — Tue, 28 Oct 2025 11:43:29 GMT

What does the following error mean and how to resolve it:

Error: Dynamic Input (5): The file "K:\Debt_Recovery\Files for Alteryx\PFA\All\Monthly MAY 2023.xlsx|||Debt_Mgmt_PFA_Monthly_202306041" has a different schema than the 1st file in the set.

Re: Dynamic input

binu_acs — Tue, 28 Oct 2025 11:57:46 GMT

@Andrej To address the schema error use the batch macro instead of dynamic input tool

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Re: Dynamic input

jrlindem — Tue, 28 Oct 2025 12:57:30 GMT

@Andrej This error is because the dynamic import tool relies on the format of the files you're bringing in to follow the same structure. It relies on the input "template" of sorts to establish the expected structure. So, when you have many files being imported it gets really very specific about them all following that same structure. As @binu_acs recommended the way around this is to use a Batch Macro.

Hope that helps, -Jay