Excel file with multiple sheets - Alteryx connection

[Narresh4ut]

On monthly i receive excel files which has multiple sheets. I would like to connect through Alteryx. could you please provide sample workflow

i have shared sample excel file as well.

[Pilsner]

Hello @jdobbins,

I believe the workflow above should already work for this. If you point the initial input data tool at your Excel file, it will dynamically read in all sheet names, even if they have changed from last month. The sheet names are fed into the batch macro, which then reads in the data from that sheet. If you're getting an error or the workflow still isn't working as expected, please let me know, and I can try to assist further.

Regards - Pilsner