Xlsx file type

[JimJohn59]

Hi all! One of the things i've seen on the learning paths (im new here) is xlsx files. Are there any requirements when importing a group of xlsx into alteryx using one input tool? 

[atcodedog05]

Hi @JimJohn59 

This article might be helpful to you for this usecase. It covers different scenarios of reading multiple files.

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

Hope this helps : )

[Luke_C]

Hi @JimJohn59 

To use one normal input tool you would have to use a wildcard input (C:\...\*.xlsx). The assumption is that every excel file has the same schema (meaning same columns, data types, etc). If the schemas are not the same you may need to look into a dynamic input or batch macro.