Is it possible to pull in an Excel file regardless of schema?

Question

I need to pull in the most recent .xlsx file from a specific location. The file name is consistent but the columns can and do change, also the schema is inconsistent. I need Alteryx to pull the file regardless of schema. Can I use a dynamic input without a template? Or is there another way to go about this?

BrandonB · Accepted Answer

Absolutely! I would highly recommend taking a look at this article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480