Hello,
I am struggling with bringing in over .xlsx 1,000 files into Alteryx. The files all have 1 sheet each; however, the sheet names are not the same across all the files. Additionally, the schemas aren't the same either; however, the first 9 columns in each file are consistent and are the only ones I need to bring in. My first row also contains data.
I've tried using a wildcard input and directory to dynamic input with no success.
Any help would be greatly appreciated.
Hi @msuria
I believe this blogpost will be useful to you.
Since the sheets have different schema you will need a batch macro and instead of using a wildcard you can use a directory tool.