Importing multiple XLSX files which are in the same folder and has different sheet names

Question

Hi I'm working with large number of xslx files which are in same folder but has different sheet name. I want to import these files in the designer without importing all with different input tools. Can anyone please tell an easy solution for this.

Thanks!

atcodedog05 · Accepted Answer

Hi @dizy_11

This blog might help you out https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

shreyanshrathod · Accepted Answer

@dizy_11 ,

Something like this should work for you.

Attaching a workflow for reference.

Let me know if it helps.

Regards,

Shreyansh Rathod