Dynamic input

[Andrej]

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.

[binu_acs]

@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

[jrlindem]

@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