Dynamic Inputs and different number of fields

[bryanmac_92]

Hello!

I am trying to pull in and read multiple data files from my directory using dynamic input tool. However, there are files that have a "different number of fields than the 1st file in the set" causing the error. Is there a fix in the workflow where the dynamic input tool ignores that that there are different schemas in each file and read the files?

There are over 1000 files in the directory so don't want to individually change each file to the schema of the 1st file.

Best,

Bryan

[apathetichell]

The fix is use a batch macro - not dynamic input.

[ScottLewis]

I don't think there's a native way to do this but you can certainly macro your way into it.

Check out this thread where somebody solved a similar problem and included the macro to do it:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Input-Different-Schema...