Dynamic Processing

[jlfromm]

I have a file that has 8 tabs the first 4 all have the same headings 

July Tab

Aug Tab

Sept Tab

Oct Tab

on my workflow 

When I run my workflow it will only read in tab Aug and I need it to read July Oct and Sept

Please let me know how to get around this.

[Felipe_Ribeir0]

Hi @jlfromm 

Instead of using the dynamic input tool, you must use the batch input macro. Take a look at the attached workflow, it will be clear how to use it. If necessary, take a look at the topic above to understand when and why use this instead of the dynamic input.

The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten

[IraWatt]

Hey @jlfromm,

The dynamic input tool requires you to have the same schema in all the files, this means the same headers and data types. You can see the difference in there schemas by dragging each of them onto a workflow and checking the metadata or use a field info tool and join tool to spot the difference. The main way round this is to use a batch macro as @Felipe_Ribeir0 said.