How to enable Alterx pick up all .xlsx input files

Question

Hi All,

I have 70 .xlsx files which starts with TH and name example TH 01 HELLO IM IN ALTERYX.xlsx and TH 02 HELLO HOW ARE YOU.xslx

In order to enable Alteyrx to pick up all 70 files I have given in Input data tool "TH *.XLSX", But even after doing that Alteryx is not picking up all files. I have verified the missing files manually and there are in .xlsx format too

How to resolve this issue?

Thanks for your time and effort

Bren_Spill2 · Accepted Answer

@Rafiuddin_333 - the files that are missing have a different schema to the files that are being picked up.

Your best bet is to use a batch macro input: Solved: Batch Macro for a dynamic input (update full path) - Alteryx Community

JosephSerpis · Accepted Answer

Hi @Rafiuddin_333 you might find this article helpful to understand why your files where not picked up with a wildcard.