How to read multiple xlsx files with one Input Tool

[jkorattiyil]

Can someone please help me to understand how we can read multiple files with one input tool. I tried "?" and "*" wildcard but only few files are reading.

[bbak91]

This is the best article to explain the different approaches of reading in data. My guess is that your data has different formats/schemas

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t... 

[IraWatt]

@jkorattiyil I would also check the results window to check for warning messages saying files are being skipped.

[binuacs]

@jkorattiyil If the file are having different schema then you will not see those records as @IraWatt mentioned check your warning or error messages in the canvas. If the files are having different schema then you should use the batch macro mentioned by @bbak91