The wildcard import method in Alteryx Designer lets one Input Data tool pull every matching Excel sheet into a single dataset automatically. This guide covers the configuration, the schema pitfalls most tutorials skip, and when to use a batch macro instead.
One Input Data tool in Alteryx can read every tab in an Excel workbook in a single pass and stack them into one consolidated output with full source traceability. This post shows the exact configuration steps and the pitfalls that catch finance analysts out.
The Alteryx Input Data tool is the starting point for every workflow and a misconfigured input causes problems that are hard to trace. This guide covers how to load Excel and CSV files correctly, what to check in the preview pane, and how to prepare your source files before you click run.